topic Re: Create date field using file names in incremental load in QlikView

Create date field using file names in incremental load

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

PFA

I would like to concatenete QVD files and create a date field based on the QVD filename ,these files are sitting in one of the folders in my computer. Please below.

Re: Create date field using file names in incremental load

Clever_Anjos — Tue, 05 Sep 2017 11:34:26 GMT

Load *,

Right(Subfield(Filename(),'.',-1),10) as Date

From [Folder\GENERAL_ACCT_MAST_TABLE_GH_*.QVD](QVD);

Re: Create date field using file names in incremental load

its_anandrjs — Tue, 05 Sep 2017 11:44:05 GMT

Write this way in load script for loading all qvds at once and by using filebasename create the datefield.

LOAD *

Date(Date#( SubField( FileBaseName() ,'_',-1),'YYYYMMDD'),'YYYYMMDD') as DateField

FROM

D:\Qcomm\GENERAL_ACCT_MAST_TABLE_*.qvd

(qvd);

LOAD *

Date( SubField( FileBaseName() ,'_',-1),'YYYYMMDD') as DateField

FROM

D:\Qcomm\GENERAL_ACCT_MAST_TABLE_*.qvd

(qvd);

Re: Create date field using file names in incremental load

its_anandrjs — Tue, 05 Sep 2017 11:58:27 GMT

Also try this you have to write this for identifying file name as well

LOAD

SubField( FileBaseName() ,'_',-1) as DateField,

FileBaseName() as FileName

FROM

GENERAL_ACCT_MAST_TABLE_GH_*.qvd (qvd);