Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am using the relation operator '<>' in the following load statement to filter out the records:
LOAD * FROM ..\Producer\DR_prd_CSV_data.qvd (qvd) WHERE (LOGIN_ID <> 'rozanne' and LOGIN_ID <> 'patric');
This is not including these two login ids into the result.
When I using the relation operator '=' to include these login ids into the records , it is not working.
LOAD * FROM ..\Producer\DR_prd_CSV_data.qvd (qvd) WHERE (LOGIN_ID = 'rozanne' and LOGIN_ID = 'patric');
How to do the string equality checking in QlikView 9 in above scenario?
Thanks in advance.
Samir
Hi Samir,
What you are trying is correct expression.
LOAD * FROM ..\Producer\DR_prd_CSV_data.qvd (qvd) WHERE (LOGIN_ID = 'rozanne' and LOGIN_ID = 'patric');
But when ur taking '<>' condition, use 'and' keyword between two conditions.
when ur taking '=' condition, use 'or' keyword between two conditions.
Regards,
Yogesh
Hi Samir,
What you are trying is correct expression.
LOAD * FROM ..\Producer\DR_prd_CSV_data.qvd (qvd) WHERE (LOGIN_ID = 'rozanne' and LOGIN_ID = 'patric');
But when ur taking '<>' condition, use 'and' keyword between two conditions.
when ur taking '=' condition, use 'or' keyword between two conditions.
Regards,
Yogesh
Thanks Yogesh for your valuable reply. It worked for me.