Text to Columns after Dynamic Input

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.

Capture.JPG

Input

Tips and Tricks

Parse

Preparation

Accepted answers

Emmanuel_G

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

All comments

Emmanuel_G

@karizze_fitzgeraldine

To solve this issue, in the dynamic input tool, can you select the line 6 "First row contains data" ?

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703