Mostly in the CSV format, text to column are not always sorted and formatted completely. By using input data tool > Row 5 > Delimiter can easily format the report for you.
For Example, if report output comes is in below format:
DATE;SALES OFFICE;COUNTRY CODE;ETC |
By entering delimiter ";" you can easily do the similar function of Text to column and data would come in this format:
DATE | SALES OFFICE | COUNTRY CODE |
Solved! Go to Solution.
Thanks for sharing @moizhlag and welcome to the Community!