Chaque semaine, découvrez de nouvelles astuces et bonnes pratiques pour devenir un expert !
Voir l'indexThe provided text files show a hierarchical structure where a "CHILD" element from one line becomes a "PARENT" element on a subsequent line. For example, "ACTIVITE" is a child on line 2, but a parent on lines 3-13. This pattern repeats throughout the data.
I need to create a mapping table that provides with the full parental link, with each columns provides with the respective generation. For instance, in column 1, all filed will be filled by "ACTIVITE", Column 2 will have only th edirect children of ACTIVITE, column 3 will have the children of each child of Activite, etc... Can you please help me ? Thanks