Forum Discussion
Split Column based on Delimiter in to Rows based on the Condition
- 4 years ago
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
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