Reading Source file and target file and mapping data from source file to target file

[Nagaraju_Julaka]

Hi All,

We have a requirement to read the data from source file and map it to target file where as the target file has to be taken as input file to read the structure(target columns) as target file structure is dynamic.

Ex: Source File has columns A , B , C
Target File has Columns W,X,Y,Z

We need to read the source file and target file and then should map the data from source file to target like below

A-> W
B->Y
C->Z

[Sowmya_Rayavara]

[quote=“Nagaraju.Julakanti, post:1, topic:9127”]

Hi Nagaraju,

Columns W,Y,Z are mandatory columns in Target Excel?

[Nagaraju_Julaka]

Yes, Those are mandatory columns