topic Re: qvd's in QlikView

qvd's

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

hi all,

iam trying to load multiple qvd's- there are totally 3 files

Set vFolder = 'D:\QVD';

for each File in filelist(vFolder& '\*.QVD')

QUALIFY*,;

UNQUALIFY ID;

[QVD multiple]:

LOAD ID,

Account,

Month,

Year,

Quantity,

Subscriber,

[SubscriberGroup],

[SubscriberPartner],

[Subscriber Center],

[Amount ],

from [$(File)] (qvd);

UNQUALIFY*;

next File

but my data model is not one.. it is generating 3 different tables . i require one ta

Re: qvd's

Chanty4u — Thu, 15 Sep 2016 07:15:46 GMT

if column names are same try below

LOAD * INLINE

Field_A, Field_B, Field_C, Field_D

];

FOR EACH vFile in FileList('C:\MYDATA*.qvd')

CONCATENATE

LOAD * FROM [$(vFile)] (qvd);

NEXT vFile

Re: qvd's

pradeep_s — Thu, 15 Sep 2016 07:16:50 GMT

Hi Raadqiptec,

Use this code

Set vFolder = 'D:\QVD';

for each File in filelist(vFolder& '\*.QVD')

Temp:

Load

ID,

Account,

Month,

Year,

Quantity,

Subscriber,

[SubscriberGroup],

[SubscriberPartner],

[Subscriber Center],

[Amount ],

from [$(File)] (qvd);

next File;

********************************************************************************

QUALIFY *;

UNQUALIFY ID;

[QVD Multipe]:

LOAD

Resident

Temp;

UNQUALIFY *;

Drop table Temp;

Re: qvd's

Anonymous — Thu, 15 Sep 2016 07:19:54 GMT

As far as i Know

One table ...one qvd (viceversa).

For you case try some JOIN in the code itself !!?

Set vFolder = 'D:\QVD';

for each File in filelist(vFolder& '\*.QVD')

QUALIFY*,;

UNQUALIFY ID;

[QVD multiple]:

JOIN

LOAD ID,

Account,

Month,

Year,

Quantity,

Subscriber,

[SubscriberGroup],

[SubscriberPartner],

[Subscriber Center],

[Amount ],

from [$(File)] (qvd);

UNQUALIFY*;

next File

Re: qvd's

pradeep_s — Thu, 15 Sep 2016 07:27:35 GMT

I believe it should be Concatenate

Re: qvd's

tracysmart — Thu, 15 Sep 2016 07:33:19 GMT

you are qualifying the tables so the field names will be likely different.

They wont auto-concatenate with the different field names.

You will have to outer join them instead

Re: qvd's

Anonymous — Thu, 15 Sep 2016 08:13:13 GMT

Hi, Don't use Qualify.

Regards!

Re: qvd's

raadwiptec — Thu, 15 Sep 2016 08:29:28 GMT

hi manua

l the probelem is i have already another table with the same fields.. to avoid it iam qualifying as they are not supposed to concatenate

Re: qvd's

tracysmart — Thu, 15 Sep 2016 08:42:41 GMT

your original question stated that you wanted one table - if you don't qualify the tables you will get one as they will auto-concatenate, if you qualify you will get multiple.

you could load it without qualifying and specify noconcatenate between them but they will be part of a big synthetic key. You would be able to resident from them or join them later though in your script.

what are you trying to achieve here?

Re: qvd's

Anonymous — Thu, 15 Sep 2016 09:00:33 GMT

Then, change the names to the fields with as.

Regards!

Re: qvd's

marcus_sommer — Thu, 15 Sep 2016 10:33:12 GMT

There are not many cases where the use of qualifying in Qlik is sensible - especially not to avoid any unwanted associations in the datamodel. Even if it worked it's better to be specific and rename the fields manually or with a rename-statement - whereby doing this does't mean mandatory that you would build a proper respectively optimized datamodel. Quite often led the attempt to reduce the number of tables (per concatenating and/or joining/mapping) to better results as the handling with many tables.

Conclusion: Qualifying is evil (unless you know exactly what you are doing).

- Marcus