Solved: Generate a field from the file name - Qlik Community

jyothish8807 · ‎2014-10-21

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

KC

Best Regards,
KC

PrashantSangle · ‎2014-10-21

Hi,

USe

FilebaseName() as Name

FilebaseName() return FileName

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2014-10-21

Hi,

USe

FilebaseName() as Name

FilebaseName() return FileName

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

anbu1984 · ‎2014-10-21

LOAD FileName() As Name,

A,

B

FROM

[ExcelFile.xls]

(ooxml, embedded labels, table is Sheet1);

alexandros17 · ‎2014-10-21

Load

....

Filename() as myFileName

From

...

Let me know

jyothish8807 · ‎2014-10-21

Thanks a lot everyone

Best Regards,
KC