PowerQuery: flatten multitable XML

[vmiki]

I've an XML with "sub tables". I've loaded into the Editor as you can see on the attached screenshot. The last column is "Table". That table has exactly 2 rows. I want to convert the first and the third columns of the subtable to columns in the main table. So having 4 new columnes (TCS_NAMA1, TCS_NAME2, TCS_STATION_IDENT1, TCS_STATION_IDENT2) instead of StationTable.

I've tried it in several way without success. Thanks in advance 🙂

[vmiki · Accepted solution]

I've found the solution, here it is 🙂

• Table.Column(Table.First([StationTable]),"TCS_NAME")
• Table.Column(Table.Last([StationTable]),"TCS_NAME")