Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to filter the List Box with some words inside it and wants to use Variable and also need to use '*'.
WHERE [Chain] LIKE '*(vR1)*'; ---this is working when i use variable. Note: i need to use variable
Thanks in advance.
WHERE [Chain] LIKE '*$(vR1)*';
Actually its not working when i use variable..
WHERE [Chain] LIKE '*$(vR1)*';
Hi,
It is working in any list box expression properties write
This are example
Ex:-
1. Let vR1 = 'T';
=if([Chain] LIKE '*$(vR1)*',[Chain])
Or in the load script it will be
2. In any load script
Raw:
LOAD * Inline [
Chain
A
BTT
dddTjh
C
T
R ];
Let vR1 = 'T';
N:
NoConcatenate
LOAD * Resident Raw Where Chain LIKE '*$(vR1)*';
DROP Table Raw;
Regards
Anand
Hi Anand, Thanks for quick response. When variable vR1 is string, its working fine. But i need to pick the certain name from the list(column) and put it in variable and use that variable to Where clause.
Hi,
You can do one thing .
When you are creating variable that time use * to concat it
like your variable like
Let vR1 = '*Name*';
Regards
Definitely it will work try to enter the TT string in the variable and load the data
Raw:
LOAD * Inline [
Chain
A
BTT
dddTjh
C
T
R ];
let vR1 = 'TT';
N:
NoConcatenate
LOAD * Resident Raw Where Chain LIKE '*$(vR1)*';
DROP Table Raw;
Yes, this works when we use hardcoded value such as TT in variable.
My requirement is to get the value in variable from the Table.
Example:
'NTNAME' is a table which has value like Jack,Ryan,Anand,..
I need to put the NTNAME inside that variable and use that variable in WHERE Clause.
Thanks.
Use WildCard function
Not working when using Variable and in LOAD Script