Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Try the approach in the attached zip:
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
It loads every date in script, so everytime i add a new date i need to change script!! This would not help!!
Hi Yogesh,
I think you can do like
LOAD *
FROM
test.csv;
you can use (*) rather than specifying the field names...
hi
no yogesh you just need to do a reload to update while you add a new date..
regards
Try the approach in the attached zip:
Thanks Jona,
Can u explain a code bit, esp. codepage is 1252 this
HI Yogesh Do as i Suggest you ..
It will solve ur problem..
Regards
LOAD [user sign up],
[sign up]
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', filters(
Transpose()
));
If i add more rows than this code is not working 😞