Forum Discussion
Split Column based on Delimiter in to Rows based on the Condition
Hello,
Thanks for seeing this Question.
I'm trying to find a solution to split column in to rows based on the Value in the Column.
In my scenario the text that determines the split is 'New'. if the Column has this text then it should be split in to seperate row and keeping other values/text in Tact.
This is the Source Data
I would like to see the Outputs as Below
I did try to include the if condition and there are errors.
Can anyone help me out please.
Regards
Hi,
In Power Query I did copy twice from particular Table :
1- in the first one,
A- I add Custom Column and use below M code : if Text.Contains([Desc], "New") then "New" else ""
B- Filter the new Column just for the rows including 'New'
C- Remove the Desc Column and rename the new column to Desc
2- In the second one,
A- I Replace the New with Space for Desc Column
B- Replace ", ," with ","
C- Trim the Desc Column
D- RightTrim the "," from the end
3- Now if Append these two ones together, the new table is included the particular rows :
Appreciate your Kudos
3 Replies
Hi karthik69 ,
Please find the below link for your reference.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thanks,
Hi,
In Power Query I did copy twice from particular Table :
1- in the first one,
A- I add Custom Column and use below M code : if Text.Contains([Desc], "New") then "New" else ""
B- Filter the new Column just for the rows including 'New'
C- Remove the Desc Column and rename the new column to Desc
2- In the second one,
A- I Replace the New with Space for Desc Column
B- Replace ", ," with ","
C- Trim the Desc Column
D- RightTrim the "," from the end
3- Now if Append these two ones together, the new table is included the particular rows :
Appreciate your Kudos
thank you all
