Connectivity & Data Prep

[wenyan1206]

Hi guys

I tried to load the txt data with space.

This data is not so perfect and includs some blank in rows,

so when I load it, some data shifts to the left.

Please tell me how I can stop data shifting and load blank as one of the data.

Thank you.

[agni_gold]

are you loading CSV file? , can you post youe sample data?

[wenyan1206]

No, I load .txt file.

I upload sample date. Please see this one.