topic Re: Another stupid question...how do I load a CSV file? in QlikView

Another stupid question...how do I load a CSV file?

Anonymous — Thu, 20 Mar 2014 20:13:52 GMT

Hi guys,

I have a CSV file that needs to be loaded into my application. I couldn't find the CSV version when I clicked "Table Files" icon...

I can find it's excel version though.

Thanks,

Lynn

Re: Another stupid question...how do I load a CSV file?

Nicole-Smith — Thu, 20 Mar 2014 20:15:51 GMT

CSV files should show up after clicking on "Table Files", just leave the "Files of type" set to "All Table Files":

Re: Another stupid question...how do I load a CSV file?

MK_QSL — Thu, 20 Mar 2014 20:16:22 GMT

Click on Table Files

Select Your CSV file

it will give you screen with Delimiter ...etc

very simple

Re: Another stupid question...how do I load a CSV file?

Anonymous — Thu, 20 Mar 2014 20:16:58 GMT

in the window where you are supposed to see your files and select one, make sure your "files of type" is "all table files". that should help!

nicole beat me to it..what she said!

Re: Another stupid question...how do I load a CSV file?

Anonymous — Thu, 20 Mar 2014 20:23:49 GMT

Thanks, guys, I found it in "Table Files" but the script looks like this:

"Directory;

Load @1

From

[.........]"

What is "@1"?

Re: Another stupid question...how do I load a CSV file?

MK_QSL — Thu, 20 Mar 2014 20:27:22 GMT

Labels >> Select Embedded Labels

This will give you column name as FieldName...

If your CSV files don't have header or Column name select

Labels >> None

and give name to your field

like below

@1 as FieldName1,

@2 as FieldName2 etc

Re: Another stupid question...how do I load a CSV file?

veidlburkhard — Thu, 20 Mar 2014 20:31:21 GMT

This is the default column header when the wizard doesn't find one. Seems you missed to mark 'Embedded Labels'.

Hope this helped.

Burkhard

Re: Another stupid question...how do I load a CSV file?

its_anandrjs — Thu, 20 Mar 2014 20:34:40 GMT

Hi,

@ is a Explicit labels if take this labels is also working but you need to change some names for your fields like

Load

@1 as Fieldname1

@2 as Fieldname2

From

[.........]"

other wise select

Labels -> Embedded labels

Hope this helps

Thanks & Regards

Re: Another stupid question...how do I load a CSV file?

Anonymous — Thu, 20 Mar 2014 20:35:41 GMT

YEAH~~ Finally, I got it successfully loaded!! Thank you guys!