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"})

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
4 years ago

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

  • Alexck's avatar
    Alexck
    Regular Visitor
    4 years ago

    Hi wdx223_Daniel ,

    Thank you very much for your input.

    It actually worked, but it only shows the CPF. The Cnpj and blanks are hidden.

    I've duplicated the function, but it overwrites the previous one. Can it be done at once?

    Thanks,

    • wdx223_Daniel's avatar
      wdx223_Daniel
      Community Champion
      4 years ago

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