Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I tried using if statement inside the pick function but, fail to achieve it. My question is it possible to achieve the scenario.
Eg: =$(=pick(vtest,'var1',if(condition1,var2,var3)))
when I stored the if statement in variable its working fine. I have multiple statements storing each and every condition takes lot of time. Could anyone help to find the alternative solution.
Regards,
Mukesh
May be you need this
=$(=pick(vtest,'col1', $(vif)))
I am a little confused here...
1) What is Col1 and Col2 and Col3? They are fields? Based on your if/pick condition, you want to get a particular field?
2) If 1) is true, then why is Col1 within single quotes and Col3 isn't?
=$(=pick(vtest,'col1',if(col2='A' or col2='B',col3)))
do you may be want col3 to be within single quotes also?
=$(=pick(vtest,'col1',if(col2='A' or col2='B','col3')))
This are things which can be easily seen through a sample. Right now all we know or see is what you are providing in your posts. Do you think you can post a sample so that we can see what you might have and what you need to get this fixed?