Forum Discussion
Advocate IData Validation - PowerQuery
Hi neil37 ,
I made a pbix file myself, which you can download and view later from the attachment.
Here're the steps in detail.
1.Duplicate Actual column.
2.Split the duplicated column with "-".
3.Change the types of the splited columns as text.
4.Add a custom column so that the number on the right half is added to 0 and combined with the number on the left half by "-".
5.After the unneeded columns are removed, the result is as follows.
Hopefully, the detailed steps above and the accessories will help you.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Advocate IHi jgordon11 & Anonymous ,
I imagine the code would work if I was starting from a blank query not connected to a specific source already? This specific task is for a source that is ingested already via an active query. I am a bit new to this language and do not see how I add this to an active query from advanced editor (i.e., which source goes where, where column names go)
Hi neil37 ,
I made a pbix file myself, which you can download and view later from the attachment.
Here're the steps in detail.
1.Duplicate Actual column.
2.Split the duplicated column with "-".
3.Change the types of the splited columns as text.
4.Add a custom column so that the number on the right half is added to 0 and combined with the number on the left half by "-".
5.After the unneeded columns are removed, the result is as follows.
Hopefully, the detailed steps above and the accessories will help you.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- neil37
Thank you, Stephen. Changing the format from whole number to text was my issue after splitting via delimeter. Greatly appreciated.