topic all qvds in one table in QlikView

all qvds in one table

surajdhall — Sat, 16 Nov 2024 03:19:13 GMT

Hi All,

I want to load all the qvd's into single table and create a new COUNTRY field in final table based on File name.
eg- if file name is Sales_ind* then COUNTRY field contain value as IND

Please note that all the qvds have slighly different fields, so we need to force concatenation using concatenate keyword.

Thanks!

Re: all qvds in one table

dplr-rn — Wed, 12 Jun 2019 20:01:15 GMT

change your script to below

Set vConcatenate = 0; For each vFile in FileList('.\*.qvd') if($(vConcatenate) = 0) THEN Data: LOAD * FROM [$(vFile)](qvd); Set vConcatenate = 1 ; ELSE Concatenate(Data) LOAD * FROM [$(vFile)](qvd); end if Next vFile

Re: all qvds in one table

rwunderlich — Wed, 12 Jun 2019 20:02:02 GMT

Data:
LOAD 0 as DummyField AutoGenerate 0;

Concatenate (Data)
LOAD *,
SubField(FileBaseName(), '_', 2) as Country
FROM [*.qvd] (qvd);

DROP Field DummyField

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: all qvds in one table

surajdhall — Wed, 12 Jun 2019 20:33:40 GMT

Thank you so much