qvd's

[raadwiptec]

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

[marcus_sommer]

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