This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Joining hierarchical data

Go to solution
kiranm
New Contributor II

โ€Ž06-28-2020 09:47 PM

Hi,
I have an excel with the data in the below format
image

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 3,4,5)
Testing (Row 6)i s parent to Manual, Automation, Load (rows 7, 8, 9)

How can I merge/join each parent (Level 1) to its childs (Level 2)?
Desired output after joining:
Name, Parent
Java, Development
dotnet, Development
php, Development
Manual, Testing
Automation, Testing
โ€ฆ

Excel attached for referencehierarchy.xlsx (10.8 KB)

Preview file
11 KB
0 Kudos
1 ACCEPTED SOLUTION

Go to solution
koryknick
Employee
Employee

โ€Ž06-29-2020 05:31 AM

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)

View solution in original post

Example_Flatten_Hierarchy_Data_2020_06_29.slp
5 REPLIES 5

Go to solution
kiranm
New Contributor II
In response to koryknick

โ€Ž06-29-2020 06:05 AM

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 ๐Ÿ™‚

0 Kudos