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.
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 :)