Forum Discussion

Alexck's avatar
Alexck
Regular Visitor
4 years ago
Solved

Table expansion not working

Hi all, I am opening a XML file and after expanding the tables I get stuck with a not expandable table, but it has data inside which should be converted into collumns.   As you can s...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

    NewStep=Table.ExpandTableColumn(Table.TransformColumns(PreviousStep,{"CpfCnpj",each if _ is table then _ else #table({"Cpf"},{})}),"CpfCnpj",{"Cpf","Cnpj"})

mussaenda's avatar
mussaenda
Community Champion
4 years ago

Hi Alexck ,

 

Can try this solution on a new custom column?

if [the column with table] = "" 
then ""
else 

Table.Column(the column with table, "Cpf")

Please let me know if it worked. If yes, you can do also for the other one which is Cnpj.

mussaenda's avatar
mussaenda
Community Champion
4 years ago

Another one I am thinking is using the Table.SelectColumns.

 

Please try the  suggestions below if it will work:

if [the column with table] = "" 
then ""
else 

Table.SelectColumns(the column with table, {"Cpf", "Cnpj"})