Forum Discussion

darshthakkar's avatar
darshthakkar
Valued Contributor
3 years ago
Solved

Consolidate Header file and Data file

Hi Team, I’m having 2 separate excel files; one containing the headers ONLY and the other one having the actual data. How can I MERGE these 2 files into a single entity so that further transformati...
pipeline
transform
  • ddellsperger's avatar
    ddellsperger
    2 years ago

    If your data is a field like languages, you could use $languages.map(obj => obj.language) to pull just those values out.

darshthakkar's avatar
darshthakkar
Valued Contributor
3 years ago
Copy LinkReport

@AleksandarAngelevski - Firstly, Thank you for sharing the solution.
Secondly, I do have some questions which needs some clarification, if you have any.

a) I have header and data file coming as separate so how do I merge it? May be a Union snap OR Join Merge?
b) If I merge the data using pointer a) above-mentioned, how do we ensure that the headers would be persistent in the first row itself?
c) Reason behind asking b) is that the router condition would be separating the first object from the rest of the data.

Thank you.