topic Generate a field from the file name in QlikView

Generate a field from the file name

jyothish8807 — Tue, 21 Oct 2014 06:59:02 GMT

Hi All,

I have 10 Excels with different names.Now i want to create a field "Name" in the table, automatically which should pull the file name into it, with corresponding to its data.

How can i do this?

Regards

Re: Generate a field from the file name

PrashantSangle — Tue, 21 Oct 2014 07:02:05 GMT

Hi,

USe

FilebaseName() as Name

FilebaseName() return FileName

Regards

Re: Generate a field from the file name

anbu1984 — Tue, 21 Oct 2014 07:02:33 GMT

LOAD FileName() As Name,

FROM

[ExcelFile.xls]

(ooxml, embedded labels, table is Sheet1);

Re: Generate a field from the file name

alexandros17 — Tue, 21 Oct 2014 07:03:39 GMT

Load

....

Filename() as myFileName

From

...

Let me know

Re: Generate a field from the file name

jyothish8807 — Tue, 21 Oct 2014 07:13:32 GMT

Thanks a lot everyone