Forum Discussion
Split columns based on delimter
Hi all,
Please help me in splitting the below column dynamically to new columns based on delimter (-). i have attached the PBIX in the below link
https://drive.google.com/file/d/15eSB8yXeyh6ANRphml6OCGNhD2yb_Ud9/view?usp=sharing
Hi ak77,
Dynamic column splitting in Power Query Editor, adapting to varying delimiters, can be achieved with clever M code manipulation.
While I'd love to explain the process in detail here, there's an excellent video available that walks you through the steps of dynamically splitting a column. I recommend watching the video and following the instructions provided, as it will guide you effectively in meeting your specific requirements.
https://www.youtube.com/watch?v=sngwN6bSV6M&ab_channel=BASensei
I also implemented the steps on the pbix you shared, to refresh my knowledge. I have attached the transformed pbix file and the Excel dataset used as the source
https://drive.google.com/drive/folders/1Op96VC20yQyZcTuNqHhDGrwXjc39K2BN?usp=sharing
Do let me know if you face any issues!
1 Reply
Hi ak77,
Dynamic column splitting in Power Query Editor, adapting to varying delimiters, can be achieved with clever M code manipulation.
While I'd love to explain the process in detail here, there's an excellent video available that walks you through the steps of dynamically splitting a column. I recommend watching the video and following the instructions provided, as it will guide you effectively in meeting your specific requirements.
https://www.youtube.com/watch?v=sngwN6bSV6M&ab_channel=BASensei
I also implemented the steps on the pbix you shared, to refresh my knowledge. I have attached the transformed pbix file and the Excel dataset used as the source
https://drive.google.com/drive/folders/1Op96VC20yQyZcTuNqHhDGrwXjc39K2BN?usp=sharing
Do let me know if you face any issues!