2 Replies Latest reply: Jun 21, 2016 3:32 PM by Andrew Walker RSS

    Loading specific strings from Table using WHERE INDEX

    Roberto guerra

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