topic Re: How to use OR in if statement in App Development

How to use OR in if statement

vikasshana — Wed, 28 Sep 2022 14:22:45 GMT

Hi,

I've below data.

ID	New	Value
1	abc	123
1	abc	456
1	abc	789
2	efg	963

I'm using the below IF statement to show the three values if I select 'abc' but it is showing only value '123'

if(match(ID,'1') and match(New'abc'),'123',if(match(ID,'1') and match(New,'abc'),'456' ,
if(match(ID,'1') and match(New'abc'),'789')))

I'm looking for an IF Statement to show all the three values if I select 'abc'.

Regards,

Vikas

@PrashantSangle @tresB @sunny_talwar

Re: How to use OR in if statement

BrunPierre — Wed, 28 Sep 2022 17:37:52 GMT

Try this

IF(Match(ID,'1') and WildMatch(New,'*abc*'),Value,Null()) as [abc Values]

Re: How to use OR in if statement

MarcoWedel — Wed, 28 Sep 2022 18:49:35 GMT

Where are you applying this expression and what is your expected result regarding those three values given that a single expression only returns a single value per evaluation?

Re: How to use OR in if statement

vikasshana — Thu, 29 Sep 2022 05:19:00 GMT

I'm trying to apply this in the load script, my expected result is if user select abc the result should be three values associated to abc (123, 456, 789)

Re: How to use OR in if statement

vikasshana — Thu, 29 Sep 2022 05:19:29 GMT

Tried this but not giving the expected result.

Re: How to use OR in if statement

BrunPierre — Thu, 29 Sep 2022 06:39:09 GMT

Hi @vikasshana

I can assure you that the syntax works perfectly. And because it's conditioned selecting the value abc won't alter the output values.

LOAD *,IF(Match(ID,'1') AND WildMatch(New,'*abc*'),Value,Null()) as [abc Values]; LOAD * Inline[ ID,New,Value 1,abc,123 1,abc,456 1,abc,789 2,efg,963 ];

O/P