Forum Discussion
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...
NewStep=Table.ExpandTableColumn(Table.TransformColumns(PreviousStep,{"CpfCnpj",each if _ is table then _ else #table({"Cpf"},{})}),"CpfCnpj",{"Cpf","Cnpj"})
Hi Anonymous ,
Thank you very much for the explanation!
Unfortunately I'm not very familiar with these codes, therefore I couldn't really understand how could I fill the data in the line you sent to me.
Could you please be so kind and explain what each comand do?
Thanks