Text to Columns after Dynamic Input

[karizze_fitzgeraldine]

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.

[Emmanuel_G · Accepted solution]

@karizze_fitzgeraldine 

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.

[karizze_fitzgeraldine]

Oh, I thought it only worked for input data. Thank you! This helps.

[Emmanuel_G]

@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.