Hi,
How do you do Text to Columns after a Dynamic Input? Photo shows an example result.
1.) Column did not convert.
2.) The data arrangement is wrong.
I used the dynamic input because the file is used daily and file name is supposed to change according to report date as well.
Solved! Go to Solution.
To solve this issue, in the dynamic input tool, can you select the line 6 "First row contains data" ?
it will allow your first line to be considered like the others and then with the text to columns tool, your headers will be well split and with a dynamic rename, you will be able to recover the first line to put it as a header.
Oh, I thought it only worked for input data. Thank you! This helps.
@karizze_fitzgeraldine Happy to help ! 🙂
In fact, some of the properties of the dynamic input are same than input tool according to the file extension.