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!

Test.csv

Input

Reporting

Data Investigation

AMP Engine

AMP-Engine

Accepted answers

binu_acs

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

Splitting_Text.yxzp

davidskaife

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:

All comments

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?

binu_acs

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

Splitting_Text.yxzp

davidskaife

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

@binu_acs

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.

Tonya_Smith

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?

pchong

Hi @TonyaS ,

I have added AMP Engine label.

Thanks!

Tonya_Smith

I actually found an existing defect that was reported by a customer to Support and escalated to us already.

Tonya_Smith

Update: This fix was included in the 2022.3 GA Release.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703