Filename as a column value

[yura_ratu]

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?

[#2 · Accepted solution]

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]

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

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

[chiru_thota]

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

Ex:

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

[yura_ratu]

It works. Thanks Cristian

[sudeepkm]

Please take a look at the example.