1 Reply Latest reply: Nov 11, 2010 1:46 PM by Karl Pover RSS

    Using Like Function in load Script

      i have loaded some data into QlikView but i am now trying to create a data island. i want to load previoulsy loaded data but this time only when it begins with A. To do this i have used the like function but QlikView doesn't seem to recognise it - has anyone any suggestions on what i can use - maybe something like begins with

      What i currently have in my script is below

       

      FundDataIsland:

       

       

       

       

       

       

       

       

       

       

       

       



       

       

      load

       

       

      Resident

       

       

       

      FundName // NAME OF TABLE WHERE DATA WAS PREVIOUSLY LOADED

      where

       

      [Fund Name] like '%A%'; // THIS IS WHERE I AM TRYING TO TELL IT TO ONLY LOAD FUNDS WHERE THE NAME BEGINS WITH A [Fund Name] as FundIsland // FUND NAME IS NAME OF PREVIOUSLY LOADED DATA