Forum Discussion
Power Query, Transform
Dear Experts, During Transformation in Power Query, in say below example in all columns I want to Split the column using the De-limiter as ":" , but I have to do them one by one, i...
In attached file a custom M function named TableSplitColumns that takes 2 arguments:
- The Table tat contains column(s) to split
- The Delimiter to split the columns
The function does:
#1 Takes the 1st record of the Table to...
#2 identify the fields/columns that contain the specified Delimiter
#3 With List.Accumulate splits each column identified at #2