How to load simple .CSV script

[#1]

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

[sunil2288]

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

[#3]

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

[#4]

Hi Yogesh,

I think you can do like

LOAD *

FROM

test.csv;

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

[sunil2288]

hi

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

regards

[jonathandienst · Accepted solution]

Try the approach in the attached zip:

[#7]

Thanks Jona,

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

[sunil2288]

HI Yogesh Do as i Suggest you ..

It will solve ur problem..

Regards

[sunil2288]

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

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

[#10]

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