Forum Discussion
Query data from unstructured text file (*.txt)
- 6 years ago
You should have "Split Column by Positions" - this is a very old Split transformation and RS should have it.
If not, the Table.SplitColumn is surely available even if not via the UI.
= Table.SplitColumn(#"Filtered Rows", "Image", Splitter.SplitTextByPositions({4, 9, 20}), {"Image.1", "Image.2", "Image.3"})That is splitting the table #"Filtered Rows" (the previous step) column [Image] into 3 new columns (Image.1/2/3) at postions 4, 9, and 20.
With that info you can manually create your step if that menu option isn't there.
- Anonymous6 years ago
Hi DAXRichArd
Try selecting the column first. In the PBI RS the ribbon changes quite a bit depending on the context.
Kind regards,
JB
Hi DAXRichArd
Try selecting the column first. In the PBI RS the ribbon changes quite a bit depending on the context.
Kind regards,
JB
Thx Jborro. I'll look again. I recall 'right-click-selecting' the column headers to see what options were there. Maybe I overlooked something. I'll pay attention again to the ribbon.
Big thanks and have a great week!
Rich Ard