topic Re: Why Wildmatch not working within script with variable ? in QlikView

Why Wildmatch not working within script with variable ?

prahlad_infy — Wed, 25 Nov 2020 16:16:04 GMT

Hi Sirs ,

What is wronging in my script ?

error

Re: Why Wildmatch not working within script with variable ?

prahlad_infy — Mon, 18 Mar 2019 13:44:40 GMT

SEARCH:
LOAD Capitalize(WHAT_YOU_WANT_TO_SEARCH) AS WHAT_YOU_WANT_TO_SEARCH

FROM
[Z:\xxxx xxxxxxx\xxxxxx\INPUT.xlsx]
(ooxml, embedded labels, table is SEARCH);

LET vINPUT = chr(42)&Peek('WHAT_YOU_WANT_TO_SEARCH',0,'SEARCH')&chr(42) ;

INPUT:

LOAD * ,
'ROW'& RowNo() AS SL ,
Capitalize(INPUT_COLUMN) as INPUT_COLUMN_T ;

lOAD * INLINE [
INPUT_COLUMN
sigmax
sigma levers
sigmata inc
cobbe
cob sons
blackfund
blackrazors
tesco
tesla
TESTRA
TORONTO
BANGlore
puner
Alaska
] Where WildMatch (INPUT_COLUMN_T,$(vINPUT)) ;

Re: Why Wildmatch not working within script with variable ?

tresB — Mon, 18 Mar 2019 13:55:06 GMT

Try using quotes like:

....Where WildMatch (INPUT_COLUMN_T,'$(vINPUT)') ;

Re: Why Wildmatch not working within script with variable ?

Marcos_rv — Mon, 18 Mar 2019 13:57:17 GMT

try this

INPUT:

LOAD * ,
'ROW'& RowNo() AS SL ,
Capitalize(INPUT_COLUMN) as INPUT_COLUMN_T ;
lOAD * INLINE [
INPUT_COLUMN
sigmax
sigma levers
sigmata inc
cobbe
cob sons
blackfund
blackrazors
tesco
tesla
TESTRA
TORONTO
BANGlore
puner
Alaska
]
Where WildMatch (INPUT_COLUMN,'$(vINPUT)') ; // solution

saludos!!!!

Re: Why Wildmatch not working within script with variable ?

marcus_sommer — Mon, 18 Mar 2019 14:00:11 GMT

Your search-string is missing the quotes. You could try it in this way:

Where WildMatch (INPUT_COLUMN_T, '$(vINPUT)')

- Marcus