Alteryx trims last white space on file load - How to stop it?

[dlesny]

I am loading the file with multiple rows to Alteryx and some of my rows have white space at the end which is being removed and I need this white space. I have marked not to trim this but it still doesn't work.

Thank you for your help.

[IraWatt]

Hey @dlesny,

Can you provide an example couple lines from your data set?

Thanks,

Ira

[dlesny]

Thank you for reply. By asking for data it made me test the format as .dat is not supported to upload here.

I converted my file to .txt and it works with white spaces as expected now. 

Thank you for your help :)