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

[#2]

I guess this will work....

LOAD *
FROM

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

[jonathandienst]

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