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!

[pchong]

Hi @TonyaS ,

I have added AMP Engine label.

Thanks!

[TonyaS]

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

[TonyaS]

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