DSXchange

Hi,

I have a scenario like source file include date like ABCD10112016.dat . I need to derive that file date value '10112016' for one of the target field.

Could you help how to reach, Moreover will get multiple files same day with different dates.

1job source files:

ABCD09112016.dat
ABCD10112016.dat
ABCD11112016.dat
ABCD12112016.dat
ABCD13112016.dat

2job source files:
EFGH09112016.dat
EFGH10112016.dat
EFGH11112016.dat
EFGH12112016.dat
EFGH13112016.dat

Assuming that the file name is a job parameter, you can manipulate that.

For example

Achieved by the file name column property in sequential file stage