CSV Delimiters Help

[pchong]

Hi community,

I have attached a sample file for my inquiry.

I am trying to import a csv file and put them into respective fields.

This is how it looks like without delimiter :

When I used delimiter "\t", the arrangement looks fine on the configuration preview.

(The nulls are supposed to be blank)

However, in the result window, the nulls are not recognized, and the values are shifted to the left because of that.

May I know what is the right delimiter to use or how do I keep the blanks/null in this case?

Thanks in advanced!

[DavidSkaife]

Hi @pchong 

Try it with \t

[pchong]

Hi @DavidSkaife ,

I did use \t but somehow it didn't work as expected (shown in screenshot on the original post).

I have taken another screenshot for reference.

Is there any other settings that I need to make?

[binuacs · Accepted solution]

@pchong One way of doing this with the text to column tool

[DavidSkaife]

Hah d'oh! Completely missed that you'd already used \t....sorry!

Interestingly \t works on my Alteryx?

[DavidSkaife · Accepted solution]

Just had a thought; do you have the AMP engine turned on?

I've just tried it on my Alteryx with it switched on (i was running the \t without it) and i've replicated the issue:

[pchong]

Hi @DavidSkaife ,

Nice!

Can you briefly explain what is the AMP engine impact on \t?

Just wondering since it might be helpful in the future.

Thanks!

[pchong]

@binuacs 

Interesting way to do text to column on column names!

Thank you

[Luke_C]

@TonyaS for awareness. I took a look through the release notes but didn't see a specific item noted for this AMP behavior.

[TonyaS]

Thank you @Luke_C  for tagging me. I am creating a defect for this one. 

Can @pchong please add the "AMP Engine" label to this post?