//////////=====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.