Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
mwoolf
Honored Contributor II

Re: Loading specific strings from Table using WHERE INDEX

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

effinty2112
Honored Contributor

Re: Loading specific strings from Table using WHERE INDEX

Hi Roberto,

                         Change your Where clause to:

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

Good Luck

Cheers

Andrew

Community Browser