Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I have a table which is my one and only source, let's call it Table1.
I need to load just certain values, and I figured out that, in order to do this, I have to use a concatenate join, as the inclusion criteria are too complex to be summarised in just one WHERE statement. A small sample below
Data | Country | OrderType | Channel | .. |
---|---|---|---|---|
.. | DE | Return | A | |
.. | DE | Order | Z | |
.. | DE | Return | A | |
.. | NL | Order | Z | |
.. | NL | Order | A | |
.. | NL | Return | Z | |
If I want, let say, a selection which includes the RETURN orders of DE customers Through Channel A and the Normal Orders of NL customers through Channel Z...
This is impossible to resolve in one single WHERE statement, as some selections are excluding the remaining data.
Thus I was thinking of doing a CONCATENATE LOAD, in this fashion:
Temp:
LOAD *;
SQL SELECT * FROM SERVER.TABLE1;
Temp1:
LOAD *
RESIDENT TEMP
WHERE Country=DE AND OrderType=Return AND Channel=A;
Temp2:
CONCATENATE (Temp1)
LOAD *
RESIDENT TEMP
WHERE Country=NL AND OrderType=Order AND Channel=Z;
For some reasons, when reloaded it does not find the table right when concatenating.
The error goes:
Table not found
concatenate (Temp1)
LOAD *
RESIDENT Temp
It seems to block when it reaches table Temp2.
Can please someone shed some light on this?
Am I asking the moon?
Thank you!
I understood my problem
I was trying to use a
"Not Wildmatch"
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??