Loading specific strings from Table using WHERE INDEX

Tue, 21 Jun 2016 18:34:02 GMT

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!!

Re: Loading specific strings from Table using WHERE INDEX

m_woolf — Tue, 21 Jun 2016 19:04:09 GMT

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

effinty2112 — Tue, 21 Jun 2016 19:32:14 GMT

Hi Roberto,

Change your Where clause to:

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

Good Luck

Cheers

Andrew