Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I need to import a document and separate it into columns by a certain number of characters, you have to do this in the Split option, however I have to do one by one, have any way to do this for several different sizes?
Example: Split table in 2 characters, after what is left of the Splip table in the 5 character, then in 10, then in 20 ...
In the excell I know that has this function of separator by fixed limit, if someone knows how to do in BI help me.
Thank you.
Solved! Go to Solution.
This can be accomplished in Power Query. When using the Table.SplitColumn function, for the argument called 'splitter', you can pass this other function which accepts a list of lengths
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
This can be accomplished in Power Query. When using the Table.SplitColumn function, for the argument called 'splitter', you can pass this other function which accepts a list of lengths
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |