Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
I'm processing an folder with XML files (SEPA Direct Debit Rejections) and have reached to this point:
When expanding the table, instead of creating new COLUMNS, each of tipe 'Table', it creates new ROWS:
The command used is:
= Table.ExpandTableColumn(#"Personalizada agregada", "Transformar archivo", Table.ColumnNames(#"Transformar archivo"(#"Archivo de ejemplo")))
Why does this happens? Is there a way to force to expand in columns?
If not? Could I move the rows to columns? I have trie to PIVOT, but it says can't pivot TABLE columns. Can I merge again the rows somehow?
Thanks!
Solved! Go to Solution.
At the end, what I did was REFER the table three times (three new tables), and, on each, filter by column (one for GrpHdr, other for OrgnlGrpInfAndSts and a last one for OrgnlPmtInfAndSts. Then I expand them separately, and JOIN them somehow later in the model.
It has been the only solution I have found. 😞
At the end, what I did was REFER the table three times (three new tables), and, on each, filter by column (one for GrpHdr, other for OrgnlGrpInfAndSts and a last one for OrgnlPmtInfAndSts. Then I expand them separately, and JOIN them somehow later in the model.
It has been the only solution I have found. 😞
Have you tried expanding on that column?
It just makes the problem bigger, as some of the new fileds are part o GrpHdr, some of OrgnlGrpInfAndSts... and so on...
Thanks for your idea, anyway 😉
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
115 | |
105 | |
95 | |
79 | |
72 |