Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a script in data load and I would like to use a concatenated column in the where condition. What is the correct way of achieving this?
LOAD "code",
LOAD "subcode",
("code" & "subcode") as "summary"
[table]:
SQL SELECT "code",
"subcode"
from table where summary not in ('A23','B21');
Ok, I just found out the syntax is quite similar to SQL. So for someone else that may have this question, a solution would be like this:
from table where ("code" || "subcode") not in ('A23','B21');
Ok, I just found out the syntax is quite similar to SQL. So for someone else that may have this question, a solution would be like this:
from table where ("code" || "subcode") not in ('A23','B21');