Incremental Loading daily on tablenames

shree909 — Mon, 08 Apr 2013 17:48:46 GMT

//////////=====Previouely loaded QVD from .csv files====================

Field_KPI_DATA:

LOAD FileName,

Field1,

Field2,

Field3,

Field4

FROM

[..\SharedDocs\QVDs\Field_KPI_DATA:.qvd]

(qvd);

///////=========Taking the filenames from the preiouly loaded QVD Files==========

TmpConcat:

LOAD concat(DISTINCT(chr(39) & FileName & chr(39)),',') AS Filenames

RESIDENT Field_KPI_DATA:;

Let vfilenamesLoaded = fieldvalue('Filenames',1);

DROP TABLE TmpConcat;

//====================================================================================

SET FilePath='*.csv';

set vFileName = 'file';

for each File in filelist ('..\SharedDocs\Files\ITEM_REPORT' & FilePath)

TRACE File = $(File);

SET sFile = '$(File)';

Field_KPI_NEW_DATA:

Concatenate(Field_KPI_DATA)

Load Filename() As FileName,

Field1,

Field2,

Field3,

Field4

FROM

[$(sFile)]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

group by

Field1,

Field2,

Field3,

Field4

next File

//Store Field_KPI_DATA Into .\QVDs\Field_KPI_DATA.qvd;

//Drop Table Field_KPI_DATA;

i want to filter on the tablenames ,

whenever i get a new table i want to load that table and concatenate to the the QVD file.

topic Incremental Loading daily on tablenames in QlikView