Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist
Specialist

How to separate fields/load data from .CSV file

Hi all,

I have a requirement in which I need to import the data from .CSV file. I am able to do it but the problem is QV is not able to separate out the values. It is taking all the values in a single field only. For example Ph no, Email, First name, Last name should be different different fields and the values shouuld should display corrresponding to the fields. But I am not able to figure it out. Any help is appreciated.

Since this site doen't support .CSV doc for uploading, I have attached the snapshot of it.

error loading image

Any help is highly appreciated.

1 Solution

Accepted Solutions
Not applicable

open file wizard and select delimited and the delimiter you use for example ;.

View solution in original post

3 Replies
Not applicable

open file wizard and select delimited and the delimiter you use for example ;.

View solution in original post

Specialist II
Specialist II

Hello, Sharma

You should use a table file wizard for loading your csv file, in this wizard you should select in "Delimeter" option value "<Custom...>", then in pop-up window you should find your symbol - "|" (number - 124) and after this QlikView will load your file correctly

Specialist
Specialist

Thanks Anatoly and Daniel for your help. This worked perfectly.