How convert a table with hierarchically linked objects into a tabke with relationally linked objects

Ask for Help
1

Hi
I have a table with objects which are linked hierarchically.

image
image453×163 9.78 KB

For example, PF1 is final product which is composed by CNF846 which is composed by TRI802, PAK1 and TRI801 which is composed by FIL357.

I want to convert this table into a new table where direct or non direct links with the parent are referenced.

image
image402×285 10.9 KB

And Each update from input table affects output table.

I use external excel data source.
I can do this transformation with power query in excel, but the actualization of the output table doesnt work when workbook is saved on the cloud. And power query request can not be actualized automatically.
So I need to open the excel doc on the desk. I trigger actualization of excel output board. After I trigger a synchronization with glide. Not very user friendly.

Is there possible to do this with glide automation only ?

2

I had something similar to do a few weeks ago. I think that Glide isn’t compatible with Power Query to update it automatically.