Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
It will not work - because this set of data sometimes are separable and sometimes not, for example:
if on my field_1 lis I will have 1 and if on my field_2 list I will have 2 then I will load ID 2 twice.
TAB:
Load
*
from XXX
where
Exists(FIELD_1);
concatenate
Load
*
from XXX
where
Exists(FIELD_2) and not exists(FIELD_1);
it will work but it will not be optimized load...
Are both fields depending to eachother in any way then you might be able to include this within the qvd-generation in an extra field. Are both fields instead completely independent to eachother then you will always need two conditions. But maybe there are further ideas from anyone if you provide some more details instead of the abstract FIELD_1/2.
- Marcus