How to return multiple values in 1 "if " statement

Hi all, I am new to alteryx. Please help me with below. question :- if USER=ABC then return ID=10,20,30 ELSE 40,50,60 END IF please help me achieve this. thanks in advance.

Preparation

Accepted answers

All comments

messi007

@shailendra88,

Could you please give more details with a sample input of the data and a sample of what you expect to have.

Best Regards,

echuong1

If I understand what you're looking for, you were on the right track. Place strings in quotation marks. You can set your output field in the expression.

Hope this helps!

New Workflow1.yxmd

shailendra88

Please find data as below:_ user id abc 10 abc 20 abc 30 abc 40 xyz 10 xyz 20 xyz 30 in workflow I want to pass only User ="ABC" and ld 10 , 20 and 30. So I was trying IF statement in filter and formula, both of then individually Like :-for ID column :- if User="ABC" then (10 or 20 or 30) else [id] endif

shailendra88

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703