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 highligh...
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}]))