Hi community,
I am trying to read the text file but i not sure how to apply text to column in this case .Would like to ask for help as per attached file
Many thanks
Attaching how far I've gotten... the headers look like they are consistent but i think there might be some structural issues with your file.
As an example, the 4th row in your text file is missing a tab indentation at the beginning of the row.
hey @SH_94
Do you have a sample of what the output should look like?
It looks like for the most part your file is tab delimited, but the pattern doesn't seem to be applied consistently.
Hi @gautiergodard ,
Yes..Kindly find the expected output below for your reference. The text file is extracted from SAP system and not sure why it is in this inconsistent format.
Thank you.
Can i know which option u choose u import the text file?
@SH_94 here is what i used:
If the file was properly formatted, usually you should be able to put "\t" variable in the delimiter field instead of the "\0" you see in my screenshot
Thank @gautiergodard ,
May i know how about this one?
Thank agains
That’s correct @SH_94
When you select “none” in the second screenshot I provided, it updates the delimiter to \0
tab = \t
space = \s
so on and so forth, you can see delimiter options at the link below.
https://help.alteryx.com/20223/designer/text-columns-tool
