Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
arsenal83
Contributor

Loading data qvd optimized

Hi,

I'm trying to load huge set of data from qvd files.

I would like to create qvd optimized import process but I need to filter data besed on 2 fields.

so I have:

TAB:

Load

     *

from

     XXX

where

     Exists(FIELD_1)

     or

     Exists(FIELD_2);

but this script is not optimized is there any chance to create optimized script with more than 1 where condition?

Tags (2)
13 Replies
Chanty4u
Esteemed Contributor III

Re: Loading data qvd optimized

Re: Loading data qvd optimized

I don't believe that this will be possible but you could try a reversed approach by combining both fields into one single-field (within the qvd and within the already loaded datatmodel). Further thinkable is to split your qvd into several qvd's - that meant to consider a complete different logic to store and reuse your data - but it isn't certain that you will get an overall benefit from them compared with your current solution.

- Marcus

arsenal83
Contributor

Re: Loading data qvd optimized

Maybe Sunny T will help me

Re: Loading data qvd optimized

What is filter conditions?

Re: Loading data qvd optimized

If you want that somebody noticed a particular posting you need to add his/her profile-link, like: stalwar1‌.

- Marcus

arsenal83
Contributor

Re: Loading data qvd optimized

It doesn't matter I have

* list of accounts and

* list of partners (ID)

I need to load all data from accout list OR partner list

Re: Loading data qvd optimized

Marcus‌ already responded to you, not sure what else may I add to his comment.

Employee
Employee

Re: Loading data qvd optimized

Since you have an OR, you can make 2 loads, the result conceptually would be the same

TAB:

Load

     *

from  XXX

where

     Exists(FIELD_1);

concatenate

Load

     *

from    XXX

where

     Exists(FIELD_2);

Re: Loading data qvd optimized

Try this:

Load multiple QVD with different fields into on... | Qlik Community

Life is so rich, and we need to respect to the life !!!
Community Browser