Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I want to filter this table with another condition , only show me data from company_id which is 1,2,3,4,5. how should i put it in my where statement, as below:
table1:
load*
FROM
[..\QVD\BASE\FACT_table1_*.qvd] (qvd)
where (name <> 'Nick' and country <> 'Thailand' and company_id = '1,2,3,4,5');
It didnt work.
Rgds,
Jim
Do you have a single company with ID 1,2,3,4,5, or are those different IDs for five different companies? If the latter:
where name <> 'Nick'
and country <> 'Thailand'
and match(company_id,'1','2','3','4','5');
Do you have a single company with ID 1,2,3,4,5, or are those different IDs for five different companies? If the latter:
where name <> 'Nick'
and country <> 'Thailand'
and match(company_id,'1','2','3','4','5');