Forum Discussion

Akshita's avatar
Akshita
New Contributor
5 years ago

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 ...
darshthakkar's avatar
darshthakkar
Valued Contributor
3 years ago
Copy LinkReport

@koryknick - Is Group By N the only way to merge multiple JSON segments into one?
Can we do it with help of a mapper snap?

  • Akshita's avatar
    Akshita
    New Contributor
    5 years ago
    Copy LinkReport

    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.

    • vaidyarm's avatar
      vaidyarm
      Contributor
      5 years ago
      Copy LinkReport

      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