Extracting items from a string

[QFanatic]

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 · Accepted solution]

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]

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

[MarcoWedel]

Why not?

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