topic Re: load multiple Excel in one table + Excel name in a column in QlikView

load multiple Excel in one table + Excel name in a column

Mon, 22 Jul 2013 09:23:57 GMT

I have a few excel files which I load into QV like this

table1:

Load

field1

field2 ...

from C:\file*.xlsx (ooxml, embedded labels, table is Part1);

That's working fine, but now I want to add another coloumn/field to my table1 which contains the excelfile name and another field which contains the spreadsheet name.

How can I change my script to add the file name and the name of the spreadsheet into the table?

Re: load multiple Excel in one table + Excel name in a column

rajni_batra — Mon, 22 Jul 2013 09:35:54 GMT

table1:

Load

field1,

field2 ,

Filename() ...

from C:\file*.xlsx

Filename function returns u the name of the file u r loading. u can check wid this .

Re: load multiple Excel in one table + Excel name in a column

Mon, 22 Jul 2013 09:38:32 GMT

perfect , so simple and I couldn't find it myself