topic Re: make excel name to field in QlikView

make excel name to field

Anonymous — Wed, 02 Mar 2016 08:36:31 GMT

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 — Wed, 02 Mar 2016 08:37:24 GMT

Hi,

use filename() or filebasename()

Regards

PrashantSangle — Wed, 02 Mar 2016 08:40:26 GMT

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 — Wed, 02 Mar 2016 08:41:05 GMT

Data:

Load FileName()

From sample.qvd (qvd);

jagan — Wed, 02 Mar 2016 08:43:33 GMT

Hi,

Try like this

LOAD

FileName() AS FileName

FROM FileName

REgards,

Jagan.