Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

load where like list of conditions

Hi all,

can you help with my trouble?

I have a list of orders with descriptions in one table.

The other table which is not linked to the first one presents a list of 90 words that I should look for in the order description.

I need to

load First table

where order_desc like '*90 words from the second file*'

Can you give me any idea how i can avoid using like '*xxxx*' 90 times and have it in one go?

Thanks a lot for any hint.

Justyna

10 Replies
Not applicable
Author

Hi Miguel,

now it works perfectly. Thank you:)

J.