topic Re: Extracting items from a string in QlikView

Extracting items from a string

QFanatic — Tue, 26 Jul 2022 11:44:07 GMT

Hi everyone,

I have an inline table lets call it X; It contains employee_number.

Load Inline [

Emp_no

123

234

345];

Later on I need to use/extract all of the employee_numbers above, in an 'in' Clause in SQL eg

select emp_no from Employee_table where emp_number in ('123','234','345')

How can I achieve this?

Thanks

pooja_prabhu_n — Tue, 26 Jul 2022 12:12:32 GMT

Hi,

You can try using Where Exists function like below:

Load * Inline [

emp_number

123

234

345];

Load *

where Exists (emp_number);

SQL Select * from Employee_table ;

QFanatic — Tue, 26 Jul 2022 13:25:24 GMT

I am joining those tables later so I don't want to do an exist in this instance

MarcoWedel — Tue, 26 Jul 2022 20:40:34 GMT

Why not?

How is the result of this solution different from what you described?