TXT Input File - Alteryx keeps pulling over data to fill instead of filling with 0

[vercimak]

How do I get it so that my txt files when they are delimited and data cleansed in Alteryx that they don't move the data over?

What's happening is that it is moving the fields to the right left to fill the empty spaces due to the data cleansing remove trailing/leading spaces but I need those blank spaces to stay so I can fill them with 0.

TXT input

Original in Alteryx

After Data Cleansing

It's reading a lot of files so going in there manually to add the zero before it runs through is not ideal.

[gautiergodard]

Hey @vercimak 

Try checking of the options below:

[vercimak]

It gave back the error "Too many fields in record #9"

[gautiergodard]

@vercimak what is the delimiter?

Looks like from your screenshot it might be tab delimiter... if that's the case you need to update the delimiter from a comma (",") to a tab ("\t") in the delimiter row of the input file.

[vercimak]

@gautiergodard 

I updated to the delimiter /t and it ran with no error but it still results in the same problem

[gautiergodard]

Are you able to use a text to columns tool to parse further ?

Try using \s as the delimiter.

[vercimak]

Yes it was already originally used to parse the data to original form but when done again it just outputs the same