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
  • Aleksandar_A's avatar
    Aleksandar_A
    3 years ago

    Hello @darshthakkar,

    If I’m understanding correctly you can achieve it by using the sl.zipObject function.

    Before that you have to turn the keys and the values in two separate arrays.

    In the router we are separating the keys (the first object) and the values by using the snap.in.totalCount function.
    Then, we append the keys to each object values and finally we zip them together.

    Please refer to the attached pipeline below:
    sl-comm-excel-headers_2023_06_12.slp (9.5 KB)

    Let me know if this helps.

    Regards,
    Aleksandar.

  • darshthakkar's avatar
    darshthakkar
    3 years ago

    Utilizing the solution provided by @AleksandarAngelevski with a minor tweak (of removing Router snap) as below:

    Thank you @AleksandarAngelevski for your time and assistance on this one, it is much appreciated.
    Closing this thread now.

    Regards,
    Darsh

darshthakkar's avatar
darshthakkar
Valued Contributor
3 years ago

I’m not planning to write the file as I need to make some transformations after the header and data have been merged.

If I had to write it off, it would have been achievable via excel formatter itself with the below settings:

And the file written would be as below:

Aleksandar_A's avatar
Aleksandar_A
Contributor III
3 years ago

Hello @darshthakkar,

If I’m understanding correctly you can achieve it by using the sl.zipObject function.

Before that you have to turn the keys and the values in two separate arrays.

In the router we are separating the keys (the first object) and the values by using the snap.in.totalCount function.
Then, we append the keys to each object values and finally we zip them together.

Please refer to the attached pipeline below:
sl-comm-excel-headers_2023_06_12.slp (9.5 KB)

Let me know if this helps.

Regards,
Aleksandar.