Discussion Board for collaboration related to QlikView App Development.
I would like to use a variable as a field in one of the tables.
How can I do that.
Thanks & Regards
let var = 5353;
load $(var) as Value ......
Actually I am using the following For statement Statement
FOR EACH file in filelist('C:\Documents and Settings\*.csv*')
Now when I am loading data from each of the files from the given folder I also want the filename as on of the fields but this attempt is giving me some error.
Please note :
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
but the following code does not work:
$(file) as filename
I am trying to use a variable as a Field.
Here is exactly what I am exactly trying to do:
FOR EACH file in filelist('C:\Documents and Settings\*.csv*') // reads all CSV files in the given folder
The above code works fine.
but I also want the the filename as one of the fields and hence I am trying the following code which throws some error.
Please let me know that where I am going wrong and how can I meet my objective of having the file name as one of the fields.
Thanks & Regards,
'$(file)' as filename