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 @shavadivu,
I used your example xml and xsd from your attached file. You can see how the csv is created.
I use XML generator for the XML, then a XML Formatter with the schema definition in order to validate the input xml, and then parsing and splitting.
Take a look into this pipeline:
Convert XML to CSV_2020_11_14.slp (11.8 KB)
/Igor
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
