Forum Discussion

kiranm's avatar
kiranm
New Contributor II
6 years ago
Solved

Joining hierarchical data

Hi, I have an excel with the data in the below format Rows at level 1 is a parent to the next subsequent rows at Level 2. For ex: Development (row 2) is parent to Java, dotnet, php (rows ...
  • koryknick's avatar
    koryknick
    6 years ago

    Attached is a pipeline that should do this a little more generically, using a Script snap as Anubhav has suggested may be necessary. The script snap is necessary, mainly because SnapLogic works on data documents and does not hold any context between. The Script snap provides a way to process the entire stream and is able to maintain that context from one document to the next.

    I hope this helps solve your problem!

    Example_Flatten_Hierarchy_Data_2020_06_29.slp (7.6 KB)

koryknick's avatar
koryknick
Employee
6 years ago

Attached is a pipeline that should do this a little more generically, using a Script snap as Anubhav has suggested may be necessary. The script snap is necessary, mainly because SnapLogic works on data documents and does not hold any context between. The Script snap provides a way to process the entire stream and is able to maintain that context from one document to the next.

I hope this helps solve your problem!

Example_Flatten_Hierarchy_Data_2020_06_29.slp (7.6 KB)

  • kiranm's avatar
    kiranm
    New Contributor II
    6 years ago

    Hi Koryknick,

    Thank you for the pipeline with the script.
    This is working and exactly what I need.
    Now I know when to you the Script snap 🙂