Forum Discussion
How to split the list into rows
Hi,
I have a list for Classification IDs and Classification columns. How to get that list to be converted to rows . Delimiter is comma.
The output expecting is below for the highlighted Classification IDs row.
| Topic title | Workflow Classification ID | Workflow Classification | Classification IDs | Classification |
| Løsning for innkassing av ventilasjon auditorium | 72 | Avvik | 111 | **bleep**Tømrar |
| Løsning for innkassing av ventilasjon auditorium | 72 | Avvik | 197 | ARK |
| Løsning for innkassing av ventilasjon auditorium | 72 | Avvik | 201 | RIVs |
| Løsning for innkassing av ventilasjon auditorium | 72 | Avvik | 209 | RIAku
|
Can you help me with this.
Thanks.
1 Reply
NewStep=Table.FromRecords(List.TransformMany(Table.ToRecords(PreviousStepName),each List.Zip(List.Transform({"Classification IDs","Classification"},(x)=>Text.Split(Text.From(Recrod.Field(_,x)??""),","))),(x,y)=>x&[#"Classification IDs"=y{0},Classification=y{1}]))
