Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i tried below edit script code for getting the data which not having the Coveo and DotNet. But it is not displaying the result what expected.
Please can anyone what should be done to achieve.
Let vT1 = Coveo | DotNet;
LOAD * Inline
[A
Android
IPhone
QlikView
Coveo
DotNet]
Where not Match(A,'$(vT1)');
Thanks in advance.
Regards
Veer
Hi,
Missed one in that.Check with this
Let vT1 = chr(39)&'Coveo'&chr(39)&','&Chr(39)&'DotNet'&chr(39);
Hi,
Check with it
Let vT1 = chr(39)&'Coveo'&chr(39)&','&Chr(39)&'DotNet';
LOAD * Inline
[A
Android
IPhone
QlikView
Coveo
DotNet]
Where not Match(A,$(vT1));
Hi
Just change your Let statement to a Set statement.
Set vT1 = Coveo | DotNet;
Regards
Jonathan
Hi Celambarasn,Jonathan
i tried both of your reply codes but generating an error message "Error in expression: ')' expected".
Is there any better way to work it ?
Thanks in advance.
Regards,
Veer
Hi,
Missed one in that.Check with this
Let vT1 = chr(39)&'Coveo'&chr(39)&','&Chr(39)&'DotNet'&chr(39);
Hi Celambrasan,
Its working fine , before we worked on providing the Let statement in script.
Now the values should be change dynamically by variable.
variable : vT1
value : =GetFieldSelections(A,chr(39)&','&chr(39))
It display the result Coveo','DotNet but i needs to get the result like 'Coveo','DotNet'
Please suggest how the expression should change to achieve this.
Thank in advance.
Hi,
Check with this
chr(39)&GetFieldSelections(A,chr(39)&','&chr(39))&chr(39)
Or
GetFieldSelections(Chr(39)&A&Chr(39),',')
Hi First expression works fine.
Thanks for your great response.
Regards
Veer
Hi Celambarasan,
i had a doubt in new concept i.;e Named CAL's.
Please can i share this with you on same post or in new post ?
Thanks in advance.