import .csv

[#1]

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

[Anonymous]

Ciao Giacomo,

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

Thank

[#3]

Giacomo,

Your file is separated by ";"?

Thank.

[#4]

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??)

[Anonymous]

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

[#6]

Giacomo,

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

Thank.

[CELAMBARASAN]

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

[#8]

here is the file

[#9]

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!

[Anonymous · Accepted solution]

try this