topic Selecting data from a qvd file using wildcards in QlikView

Selecting data from a qvd file using wildcards

Wed, 03 Feb 2010 13:02:53 GMT

Hi,

I have a need to select data from a QVD file based on the contents of an excel spreadsheet, the added complication is that I need to match only on part of the string, I can build the string from the spreadsheet ok.

Example:

// String build from Spreadsheet

LET String="a like 'fre%' or a like 'ber%'"

In SQL speak I could do

select a, b, c
from table
where ($(String));

Is there a way of doing it from a QVD file ?

Thanks

Tony

Selecting data from a qvd file using wildcards

disqr_rm — Wed, 03 Feb 2010 14:45:54 GMT

Hi Tony,

Yes, that would work in SQL but in QV you would need to use MATCH() or WILDMATCH() functions. So something like below should work fine:


let mask1 = chr(39) & 'fre*' & chr(39);
let mask2 = chr(39) & 'ber*' & chr(39);
LET String = 'WILDMATCH(a, ' & mask1 & ') > 0 OR WILDMATCH(a, ' & mask2 & ') > 0' ;
LOAD a FROM a.qvd (qvd)
WHERE $(String);

Selecting data from a qvd file using wildcards

Wed, 03 Feb 2010 14:48:22 GMT

The following code should help...

LOAD * FROM FileName.QVD (qvd) WHERE WILDMATCH(FieldName, '*ZZ*');

Selecting data from a qvd file using wildcards

Wed, 03 Feb 2010 15:43:44 GMT

Thanks That worked perfectly

Tony