topic How to load simple .CSV script in QlikView

How to load simple .CSV script

Thu, 02 Sep 2010 10:33:12 GMT

Hi,

I am new here, I have below type of .csv file, where every day a new date to be added in a coulmn in csv sheet.

Can anyone help me with a script to load this data in QVW to make charts, and when i add a date coulm everyday i just need to reload file rather than changing script again and again

----------------------------------------------------------------------------------------

user sign up	8/4/2010	8/5/2010	8/6/2010	8/7/2010
sign up	993	1056	1192	991

How to load simple .CSV script

sunil2288 — Thu, 02 Sep 2010 10:48:10 GMT

HI Yogesh,Go to Edit script window below there is a button Table files click on that.then

in File type check on delimited and Delimiter as comma lebels as Embedded labels then finish.

Hope it will solve ur problem

Regards

Sunil

How to load simple .CSV script

Thu, 02 Sep 2010 10:53:13 GMT

It loads every date in script, so everytime i add a new date i need to change script!! This would not help!!

How to load simple .CSV script

Thu, 02 Sep 2010 10:54:37 GMT

Hi Yogesh,

I think you can do like

LOAD *

FROM

test.csv;

you can use (*) rather than specifying the field names...

How to load simple .CSV script

sunil2288 — Thu, 02 Sep 2010 10:58:35 GMT

no yogesh you just need to do a reload to update while you add a new date..

regards

How to load simple .CSV script

jonathandienst — Thu, 02 Sep 2010 11:04:24 GMT

Try the approach in the attached zip:

How to load simple .CSV script

Thu, 02 Sep 2010 11:21:02 GMT

Thanks Jona,

Can u explain a code bit, esp. codepage is 1252 this

How to load simple .CSV script

sunil2288 — Thu, 02 Sep 2010 11:33:12 GMT

HI Yogesh Do as i Suggest you ..

It will solve ur problem..

Regards

How to load simple .CSV script

sunil2288 — Thu, 02 Sep 2010 11:34:30 GMT

LOAD [user sign up],
[sign up]
FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', filters(
Transpose()
));

How to load simple .CSV script

Thu, 02 Sep 2010 11:46:46 GMT

If i add more rows than this code is not working 😞

How to load simple .CSV script

Thu, 02 Sep 2010 11:50:16 GMT

I guess this will work....

LOAD *
FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', filters(
Transpose()
));

How to load simple .CSV script

jonathandienst — Fri, 03 Sep 2010 08:58:47 GMT

Load statement explained:


LOAD @1 as SignDate,
 @2 as SignUp
FROM
SignUp.csv
(txt, codepage is 1252, no labels, delimiter is ',', msq, filters(
Transpose(),
Remove(Row, Pos(Top, 1))
));

txt - load type = text file
codepage - set up by table wizard acc to the text encoding
delimiter is ',' - use comma delimited format
msq - standard quoting
filters - set up any processin filters - in this case transpose() is what turns the data into two columns of text, and the remove gets rid of the now redundant field name row.

Hope that helps

Jonathan