How to create a flat list of node IDs & descriptions for multiple nodes of a hierarchy

[Charl]

Hi,

I have a hierarchy in table format, consisting of 10 node IDs with node descriptions.

I want create a flat list of unique node IDs and node descriptions to be used as a VLookup table - thus show all node IDs (level 1 to 10)  in one column with their corresponding node descriptions in another column (thus only having 2 columns, one for IDs and the other for descriptions)..

I attached an example of node IDs and node descriptions for which I want to test this concept. Further down is how the solution should look lik.

Your help would be appreciated.

Regards

Charl

Solution should look like this:

[davidskaife · Accepted solution]

Hi @Charl 

Here is one way to do it, for more Nodes simply add an additional Transpose tool per node required:

Cheers,

David

[Charl]

Hi David, 

Thank you for the quick response!

This works perfectly, thank you! I appreciate your help.

Rgds

Charl