Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My requirement is to get the value in variable from the Table and use in WHERE Clause in Load Script.
Example:
'NTNAME' is a table which has value like Jack,Ryan,Anand,..
Variable vR1 stores values from NTNAME.
I need to put the NTNAME inside that variable and use that variable vR1 in WHERE Clause and need to use Wilcard '*'
=IF(WildMatch([Chain],'*$(vR1)*'),[Chain])
Thanks in Advance.