actually (I haven't tried this specifically now), you are right.
I remember couple weeks ago, that I had to concatenate a huge table split in two csv files, that by loading them one right after the other, it will concatenate them.
Without concatenate expression.
I 'm lost then what is the meaning of the concatenate load, if qlikview is concatenating by default??
Temp1 is concatenated to Temp because both the table has same number of fields with same filed names.
Why not you can do this in single where statement?
What's wrong if you do in this way?
SQL SELECT * FROM SERVER.TABLE1;
WHERE (Country=DE AND OrderType=Return AND Channel=A) OR (
Country=NL AND OrderType=Order AND Channel=Z);
Drop Table Temp;//If you don't need the Temp table then drop it
Hope it helps
You are right, in this case I could use it.
My exapmle is not portraying the truth 100%.
I'm trying to achieve something like
WHERE ((Not WildMatch(Country,'DE') AND OrderType=Return AND Channel=A) OR (
Country=DE AND OrderType=Order AND Channel=Z);
According to the data I receive after the load, the first part of the WHERE statement is excluding the 'DE' records, therefore when in the second part I need a part of these 'DE' records, they are not found.
And I can't reverse the order (I think), because also the second part of the WHERE statement is actually a Not WildMatch
Your expression works in correct way only know?
Your expression works like Country that is not DE with Return Orders in Channel A or Country DE with Orders in Channel Z.
If it is possible to do in Two different where conditions then it can be possible in single where statement.
Where (condition1) or (condition2);
Yes.Splitting where statements works in way you explained.
QV is going through 1mln lines looking for DE, then starting all over goign through the 1mln lines looking for NL
If you combine this in a single where statement then it does in single process. No need to check the whole table again for your condition.
I understood my problem
I was trying to use a
in a SQL statement.
For a beginner like me, these different ways of expressing WHERE/IF statements are confusing;
QV language, SQL language...maybe also access databases using a different languages?
Anyone aware of such a thing as a summary table where all the "translation" in all the different languages are to be found??