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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.