topic import .csv in QlikView

import .csv

Tue, 28 Feb 2012 12:50:10 GMT

Hi everybody,

I am reaaly new with the use of qlick view. and I'm starting my stage in these days. I was asked to do a simple job but I am not able to do it.

I have to import a .csv file but I'am not able to split in more colums the data that are all in the first column.

Someone can help me writing the correct script I should use or the main steps required!

I would be reaaly grateful,

Thank you,

Giacomo

import .csv

Anonymous — Tue, 28 Feb 2012 12:54:42 GMT

Ciao Giacomo,

can u upload the CSV and explain better wath u need?

Thank

import .csv

Tue, 28 Feb 2012 13:10:51 GMT

Giacomo,

Your file is separated by ";"?

Thank.

import .csv

Tue, 28 Feb 2012 13:16:39 GMT

I have all tha data in the first column, and I would like to split it. the different column are divided by a Comma!

I'm able to do it with excel but importing the file in qlikview not really!

attached you could find the file! there are only the firs two raws to give an idea!

thanks a lot

Giacomo

(where can I add the sample file??)

import .csv

Anonymous — Tue, 28 Feb 2012 13:21:05 GMT

When u answer use advanced editor ( up on the right) then u can upload csv

import .csv

Tue, 28 Feb 2012 13:23:58 GMT

Giacomo,

Click Replay and go in the top header and click on "Insert Image".

Thank.

import .csv

CELAMBARASAN — Tue, 28 Feb 2012 13:26:06 GMT

Hi,

Go to the Edit script dialog where the load script will be.

At the bottom you have tabs in that data tab you can find the table file button click on that.

It ask you to choose the file.

After choosing you will be guided by that dialog.

Celambarasan

Re: import .csv

Tue, 28 Feb 2012 13:27:36 GMT

here is the file

Re: import .csv

Tue, 28 Feb 2012 13:49:03 GMT

Mandeli,

Follow the example file.

1 - Press Ctrl + E

2 - Press 'table files' select your file

3 - 'separator' select 'Comma'

4 - Click on 'Finish'.

5 - Press F5

READY!

Thank!

Re: import .csv

Anonymous — Tue, 28 Feb 2012 13:49:23 GMT

try this

Re: import .csv

Mon, 02 Jun 2014 03:24:22 GMT

I had imported .csv sample data using your steps.
However after the loading is done, in "MAIN" tab I don't see my data at all.

During the loading Wizard I saw all the data available though...
What has just happened?