Could you please give more details with a sample input of the data and a sample of what you expect to have.
Best Regards,
Thanks,
is there anyway i can write your statement in IF statement, so that in future if i want to process other user also it should not block them, like for USER=‘ABC’ then it will process only 10,20 and 30 but if i get any other User then it should not block them,
Like if I get user EFG then it should process all the related id.
i thinks if we write your statement under IF or IIF or SWITCH that can resolve the issue,
but I am not able to do so.
I tried as below:-
IF USER=“ABC” then ID IN(10,20,30)
else ID
ENDIF
APOLOGY if i am not able to explain properly.
Thanks a lot,
in you statement we are returning”10,20,30” that is term as 1 string output, now consider 10,20 and 30 as separate ids,
how can we write same statement,
i tried as below but didn’t work for me:-
if user=“ABC” then id in(“10”,”20”,”30”)
else ID
end if
in this case if ABC then it will process 10,20 and 30 but if any there user is there then all the ids will be processed for that user
In this case you can use:
1-
if user=“ABC” then
if id in (“10”,”20”,”30”)
then "10"
else ID
else ID
endif
OR
2-
if user=“ABC” and id in (“10”,”20”,”30”)
then "10"
else ID
endif
With If statement you have to add else statement
Hope this helps,
Regards,