Forum Discussion
Extract before/after delimiter
Hi all
After extracting before or after delimiter in power query, the original column is totally replaced by the extracted column. I have to go to the previous step to see the original column. This happens for some and for some it creates a new column for the extracted values (This is what I want). How can I stop it from overwriting the original column and why does power query choose the columns it does this to?
Anonymous if you are using transformation it will just update the existing column, maybe add a new column and copy the code of before or after delimiter as part of this new add column and it will keep your original column and you will have a new column.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hi Anonymous,
Here is the source table:
Insert step after:
Extract before/after delimiter
Here is the output:
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
2 Replies
Anonymous if you are using transformation it will just update the existing column, maybe add a new column and copy the code of before or after delimiter as part of this new add column and it will keep your original column and you will have a new column.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hi Anonymous,
Here is the source table:
Insert step after:
Extract before/after delimiter
Here is the output:
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!