Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys I have data like this two columns ticket I'd, order id
Ticket I'd ,ordered
1, 2763627,A6727277,387272
2, 6272778,U7277273
3, 727336
I want convert it as
1 2763627
1 A67272...
1 3873.....
2 6272..
2 U72...
3 .....
Solved! Go to Solution.
You can do this with just a few clicks using Split Column > By Delimiter and choosing to split into rows under the advanced options:
You can do this with just a few clicks using Split Column > By Delimiter and choosing to split into rows under the advanced options:
NewStep=#table(Table.ColumnNames(PreviousStepName),List.TransformMany(Table.ToRows(PreviousStepName),each Text.Split(_{1},","),(x,y)=>{x{0},y}))