Unnesting Tables of entire column

[Anonymous]

Hello Power BI community,

I'm looking for a solution to unnesting tables. This is what I have: 

The tables are filled with three possible values: False, True or an empty string. 

How do I extract these values? This is what a table looks like: 

My expected result is a column with all the Tables in the column replaced by their values (True, false or empty string/null)

If anything needs clarification I'm happy to answer. Thank you for your help in advance.

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

According to your description and sample picture, I’ve also created a similar query as yours using the M language, then I figured out a way to achieve this, you can try my steps:

This is my original query:

1. Convert the data type of this column to “True/False” or “Text”:

2. Click on the column and select “Repalce errors”, enter “null”:

And you can get what you want, like this:

You can download my test pbix file below

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.