Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
yura_ratu
Partner - Creator II
Partner - Creator II

Filename as a column value

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?

1 Solution

Accepted Solutions
Not applicable

Hi Yuriy

filename()   function will return blablabla_partner_blabla_date.csv

subfield function will get string delimited by '-'

so

load

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

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

FROM ...

best regards

chris

View solution in original post

5 Replies
Not applicable

Hi Yuriy

filename()   function will return blablabla_partner_blabla_date.csv

subfield function will get string delimited by '-'

so

load

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

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

FROM ...

best regards

chris

preminqlik
Specialist II
Specialist II

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

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

chiru_thota
Specialist
Specialist

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

Ex:

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

yura_ratu
Partner - Creator II
Partner - Creator II
Author

It works. Thanks Cristian

sudeepkm
Specialist III
Specialist III

Please take a look at the example.