Error in File importing

[SJBI]

Hi All,

I'm new to this tool. The issue I'm facing is When I try to import .txt file which is ";" delimeted file. I'm not able to view the data in the Preview part. Could you help me in resolving this issue plese.

[AndrewW]

What you have done should work. Are you able to post a sample of the file?

[SJBI]

My data is looks like.

locatin;Financial Company;email;Customernumber;status

US;1;abc@gmail.com;1234;Active

US;2;abcd@xyz.com;1233;Active

In preview I dont see the data.

[s_pichaipillai]

@SJBI

It works for me when i used ; as delimiter

can you check the Input file configuration and it should look like below

Make sure the file is not opened when you click on Preview :)

[AndrewW]

Yes, works for me as well. Not sure why you're having problems.

[SJBI]

Hmm.. I will check with source file once again and come back to you.

[SJBI]

Small Change 

My data is looks like

locatin;Financial Company;email;Customernumber;status

US;1;abc@gmail.com;1234;Active;

US;2;abcd@xyz.com;1233;Active;

[AndrewW]

Ok, makes sense now. You have fewer headers than data columns. Add an additional ; at the end of your header row OR remove the ; at the end of the data rows.

[s_pichaipillai]

try this as well

configure your input with NO delimiter i.e \0

then use parse tool and split the col into 5

then use formula to REPLACE the end ';' 

test the attached workflow

[SJBI]

Thank you for the reply. I got one more Issue.

I have totally 47 columns in my source  and in 22 column I have data with special characters .

There Error as:  

There are multiple Fields names "xxxx;xxxxx;xxxxx;xxx"