Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading specific strings from Table using WHERE INDEX

Dear Qlik Community!

I need your help once more, please! I have a big file where i'm storing thousands of tweets that are categorized by groups, brands, etc.

How could I load data into my Qlik Model that only considers certain categories? Would it have to be with an index function?

I'm trying

load * from 'C:\qlikview\Redes Sociales\CanastaTwitter\TwitterSearchTerms*.qvd' (qvd)

where index(Grouping(),'Retail')=1;

And it doesnt work. It just stops at that part of the script.

Any ideas? I need to extract all the accounts that are associated to that Grouping (Which is the name of the column) from a single file.

Thanks!!

2 Replies
Master II
Master II

where index(Grouping,'Retail')>0;

Master
Master

Hi Roberto,

                         Change your Where clause to:

Where WildMatch(Grouping, '*Retail*');

Good Luck

Cheers

Andrew