topic Re: Loading Multiple QVDs with wildcard in App Development

Loading Multiple QVDs with wildcard

dafnis14 — Mon, 30 Apr 2018 05:29:02 GMT

Hi,

I'm using the following script to load identical QVD files:

Targets_Metrics:

LOAD *,

Target_Date as Date

From $(vPathTempData)Target_NO*.qvd (qvd);

STORE Targets_Metrics into $(vPathQVD)Targets_Metrics.qvd (qvd);

DROP Table Targets_Metrics;

But after dropping the table, there is a table with that name left in the model:

Why does it happen?

Thanks!

Re: Loading Multiple QVDs with wildcard

jonathandienst — Mon, 30 Apr 2018 05:34:27 GMT

The QVD files do not have identical fields, so the QVD was not concatenated and a -1 table was created. The DROP table references the original table only. This script will enforce the concatenation:

Targets_Metrics:

LOAD 0 as Date AUTOGENERATE 0; // create empty table as concatenation target

Concatenate(Targets_Metrics) //force concatenation

LOAD *,

Target_Date as Date

From $(vPathTempData)Target_NO*.qvd (qvd);

STORE Targets_Metrics into $(vPathQVD)Targets_Metrics.qvd (qvd);

DROP Table Targets_Metrics;

Re: Loading Multiple QVDs with wildcard

dafnis14 — Mon, 30 Apr 2018 08:22:57 GMT

Thanks, Jonathan!

Tremendous help!

You are right... the tables were not identical..

The original script did concatenate and stored only the identical ones, and the table Target_Metrics-1 has the different one...