Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a which have 3 columns and data is like:
Name | Parent | Level
All | All | 1
Toys | All | 2
Vehicles | Toys | 3
Cars | Vehicles | 4
I need to flatten this hierarchy structure and the result should look like the below:
Name | parent_1 | parent_2 | parent_3 |
All | (NULL) | (NULL) | (NULL) |
Toys | All | (NULL) | (NULL) |
Vehicles | All | Toys | (NULL) |
Cars | All | Toys | Vehicles |
How can do this in Talend?