Forum Discussion
Solved
Problem when expanding XML table fields to rows instead of columns
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 'Ta...
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 😉