topic AW:Using a Variable as a a Field in a Table in QlikView

Using a Variable as a a Field in a Table

Mon, 14 Jun 2010 09:11:54 GMT

Hi,

I would like to use a variable as a field in one of the tables.

How can I do that.

Thanks & Regards

AW:Using a Variable as a a Field in a Table

biester — Mon, 14 Jun 2010 09:27:47 GMT

e.g.:

let var = 5353;

load $(var) as Value ......

Rgds,
Joachim

AW:Using a Variable as a a Field in a Table

Mon, 14 Jun 2010 10:23:10 GMT

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 :

FOR EACH file in filelist('C:\Documents and Settings\*.csv*')

TEMP:

LOAD

Field1,

Field2

FROM

[$(file)]

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

but the following code does not work:

FOR EACH file in filelist('C:\Documents and Settings\*.csv*')

TEMP:

LOAD

Field1,

Field2,

$(file) as filename

FROM

[$(file)]

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

AW:Using a Variable as a a Field in a Table

Mon, 14 Jun 2010 10:35:20 GMT

Hi,

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

TEMP:

LOAD

Field1,

Field2

FROM

[$(file)]

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

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.

FOR EACH file in filelist('C:\Documents and Settings\*.csv*')

TEMP:

LOAD

Field1,

Field2,

$(file) as filename

FROM

[$(file)]

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

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,

Rohit

AW:Re: AW:Using a Variable as a a Field in a Table

biester — Mon, 14 Jun 2010 11:25:05 GMT

Try

'$(file)' as filename