1 Reply Latest reply: Nov 11, 2010 12:51 PM by Miguel Angel Baeyens de Arce 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 [Fund Name] as FundIsland

      // FUND NAME IS NAME OF PREVIOUSLY LOADED DATA

       

       

       

       

       

       





       

       

       

       



       

       

      Resident FundName

       

       

      // FundName is name of previous table where data was 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



       

       

       







        • Using Like Function in load Script
          Miguel Angel Baeyens de Arce

          Hi,

          Use one of the following:

           

          FundDataIsland:load [Fund Name] as FundIsland// FUND NAME IS NAME OF PREVIOUSLY LOADED DATAResident FundName // FundName is name of previous table where data was loadedwhere LEFT([Fund Name], 1) = 'A';


          or

           

          FundDataIsland: load [Fund Name] as FundIsland// FUND NAME IS NAME OF PREVIOUSLY LOADED DATAResident FundName // FundName is name of previous table where data was loadedwhere WildMatch([Fund Name], 'A*');


          That should work.

          Regards