topic Re: Flatten hierarchy in Talend Studio

Flatten hierarchy

prabinpatroc1 — Sat, 16 Nov 2024 03:18:35 GMT

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?

Anonymous — Tue, 11 Feb 2020 04:34:22 GMT

Hi
The result output is unreadable, can you please edit it or write the result in a file and upload a screenshot?

Regards
Shong

prabinpatroc1 — Tue, 11 Feb 2020 13:10:33 GMT

Attached spreadsheet has input and output data.