make excel name to field

[Anonymous]

Hi everyone

I have multiple tables with the same filed names but for the different months, in fact my excel names are month and year names.

I want to convert excel name to a field month and year in qlikview.

Is it possible?

I would appreciate if anyone can help me.

[PrashantSangle]

Hi,

use filename() or filebasename()

Regards

[PrashantSangle · Accepted solution]

Hi,

FilebaseName gives you

Returns a string containing the name of the table file currently being read, without path or extension.

and filename() returns

Returns a string containing the name of the table file currently being read, without path but including the extension.

then use Subfield(),mid(),Month(),Year() as per requirement.

Regards

[Chanty4u]

Data:

Load FileName()

From sample.qvd (qvd);

[jagan]

Hi,

Try like this

LOAD

*,

FileName() AS FileName

FROM FileName

REgards,

Jagan.