Using Like Function in load Script

Thu, 11 Nov 2010 17:45:10 GMT

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 — Thu, 11 Nov 2010 17:51:26 GMT

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';

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

topic Using Like Function in load Script in QlikView

Using Like Function in load Script

Using Like Function in load Script