Txt input space removal

Question

I tried to use input tool to import txt format data to Alteryx, the length of one field is fixed at 7 maybe contain some spaces in it. But I found Alteryx remove the leading and trailing space directly without use of data cleansing tool. I just want to keep the same length of original format and string length. Thank you!

Ex:

txt input               Alteryx Length

MMMMMMM              7

MM              2

WenjingLiao · Answer

Thanks very much for your reply.

Yes, it is. Alteryx will automatically trim whitespaces once I import txt import by reading it as delimited txt file. But I have to use delimited txt file to import since my raw data has many fields, so that I can not use read it as a fixed width .

Do you know how to set configuration to deselect “trim whitespace”？

Thank you very much！

shancmiralles · Answer

From my end, if this is a .txt file -  whenever I pull the data into the canvas a pop up window will appear called "Resolve File type".

There are three options to choose from:

1)Read it as a built in type

2)Read it as a fixed width text file

3)Read it as a delimited text file

Whenever I choose option #2, it gives me the "Flat File Layout" option  where i can indicate the length of the data.

not sure if it will work from your end , but hopefully it does.

cheers!