topic Re: Field Name variable in QlikView

Field Name variable

brunopaulo — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

Im doing a For each cycle for load several excel files. Its something like this.

FOR EACH File in FileList ('..\Dados\Matriz de Polivalência *.xls')

Table1:
Date(field1) as Date,

Name as Area

From $(File)

...

I want to change the name field depending on the file, but i have no idea how to do.

Can anyone help me?

Thank you
Best Regards,

Bruno Paulo

YoussefBelloum — Mon, 20 Nov 2017 16:19:13 GMT

Hi,

Maybe this:

FOR EACH File in FileList ('..\Dados\Matriz de Polivalência *.xls')

Table1:
Date(field1) as Date,

if($(File)='the name you want', name,'else...') as Area

From $(File)

...

brunopaulo — Mon, 20 Nov 2017 16:21:17 GMT

Hi i'm not sure how to play there are 7 files with 7 differente Field Name dat i want.

Can u develop a bit more? Thank You

Best Regards

Bruno Paulo

brunopaulo — Mon, 20 Nov 2017 16:23:06 GMT

how to apply*

YoussefBelloum — Mon, 20 Nov 2017 16:27:20 GMT

'I want to change the name field depending on the file' => what are the name fields you want for each name file ?

can you post a mapping table ?

brunopaulo — Mon, 20 Nov 2017 16:29:24 GMT

I dont have Mapping table because im manually defining the name field. But i did better i gave excel name so solved my problem Thank you