Mapping source to target columns
Hi All,
We have two input files source and target with different number of columns in both files.
We need to map the source column to target column and the sequence of columns in source file is ...
Forum Discussion
Hi @ForbinCSD,
Thank you for the response.
Source and target are two different input files and both are in csv format. I am attaching a sample scenario for further understanding.
In the screenshot attached - input1 is the source file which will contain column headers and data. Input 2 is the target file which will contain only column headers.
Output is the format we require.
Basically input2 is the output format, we need data from input1 in input2 file for respective matched columns.
columns.
try to read the source data and the output file first and then use join snap(probably merge), filter the null columns(those which are not present in both) then you can perform mapping the required fields.
Thanks
