How to filter the "Table"

[ngct1112]

Hi, I am trying to Parsed XML, after I expand the XmlValue, there are 2 columns, which 1 column value contain "Table".

However, I do not find a way to expand them all. May I know is there any way I could filter "Table" alone then expand them? or there are any better way to deal with XML?

Thanks a lot

[Syndicate_Admin]

I find the solution here that can expand the tables within a column.

https://community.powerbi.com/t5/Desktop/Expand-Column-Containing-Some-Tables/m-p/409196

[ngct1112 · Accepted solution]

I find the solution here which can expand the Tables inside a column.

https://community.powerbi.com/t5/Desktop/Expand-Column-Containing-Some-Tables/m-p/409196

[PhilipTreacy]

Hi @ngct1112 

Click on the down arrow in the top of the column header then uncheck everything and click OK.

You should then have a column of tables that you can expand by clicking on the double headed arrowin the column header

regards

Phil

[ngct1112]

@PhilipTreacy It is a soluction but with this method, there are 2 problems,

1.) The script beomes so long 

2.) will not filter out the updated data