Why Wildmatch not working within script with variable ?

[prahlad_infy]

Hi Sirs ,

What is wronging in my script ?

error

[prahlad_infy]

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

[tresesco · Accepted solution]

Try using quotes like:

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

[Marcos_rv]

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!!!!

[marcus_sommer]

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

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

- Marcus