topic Re: Filename as a column value in QlikView

Filename as a column value

yura_ratu — Fri, 04 Apr 2014 11:47:39 GMT

Every day I received reports from partners with standard name "blabla_<PartnerName>_blabla_<date>.csv". Which have same columns. How can I add Two columns -- Partner and Date, which will be filled by values from filenames?

Re: Filename as a column value

Fri, 04 Apr 2014 11:51:27 GMT

Hi Yuriy

filename() function will return blablabla_partner_blabla_date.csv

subfield function will get string delimited by '-'

load

subfield(filename(), '-', 2) as partner,

subfield(filename(), '-', 4) as date

FROM ...

best regards

chris

Re: Filename as a column value

preminqlik — Fri, 04 Apr 2014 11:51:46 GMT

subfield(filebasename(),'_',-1) as Date,

subfield(filebasename(),'_',-3) as Partner

Re: Filename as a column value

chiru_thota — Fri, 04 Apr 2014 11:56:24 GMT

You can use FileName() function and sub field function to capture the Patner name and Date.

Ex:

Load *,FileName() as FN ..............

Re: Filename as a column value

yura_ratu — Fri, 04 Apr 2014 11:57:27 GMT

It works. Thanks Cristian

Re: Filename as a column value

sudeepkm — Fri, 04 Apr 2014 12:01:19 GMT

Please take a look at the example.