Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
CostinelRO
Contributor II
Contributor II

Concatenante column in data load

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');

Labels (1)
1 Solution

Accepted Solutions
CostinelRO
Contributor II
Contributor II
Author

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');

View solution in original post

1 Reply
CostinelRO
Contributor II
Contributor II
Author

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');

View solution in original post