Field Name variable

[brunopaulo]

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 · Accepted solution]

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]

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]

how to apply*

[YoussefBelloum]

'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]

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