Need below mentioned formula updated in Alteryx

[mmustkee]

Hi Team,

I am looking for formula ( =IF(OR(AND([@PredCarrier]=[@[Air ff ]],[@PredCarrier]<>"NULL"),AND([@PredCarrier]<>"NULL",FIND([@PredCarrier],[@program])>0)),"Y","N")

to be applied in Alteryx.

Please discard Empty value also in ( PredCarrier & Air ff  like NULL) and mark them as "N"

Please refer attached.

[cjaneczko]

Try the following.

IF(([PredCarrier] = [Air ff ] AND [PredCarrier] != "NULL") 
  OR ([PredCarrier] != "NULL" AND FINDSTRING([program],[PredCarrier]) > -1)) Then "Y" else "N" endif

[cjaneczko]

Sorry i just reread your requirements. Try the following.

IF(IsNull([PredCarrier]) and isnull([Air ff ])) then 'N' elseif(([PredCarrier] = [Air ff ] AND [PredCarrier] != "NULL") 
  OR ([PredCarrier] != "NULL" AND FINDSTRING([program],[PredCarrier]) > -1)) Then "Y" else "N" endif

[Deano478]

@mmustkee based on how you phrased that question may I ask did you at least attempt to write this expression yourself before asking for a solution?

[mmustkee]

@cjaneczko 

Apologies my result was incorrect. Please apply formula which I attached i.e. (

IF(OR(AND([@PredCarrier]=[@[Air ff ]],[@PredCarrier]<>"NULL"),AND([@PredCarrier]<>"NULL",FIND([@PredCarrier],[@program])>0)),"Y","N")

.

I have uploaded new sheet and result is correct. Kindly match result and advise.

Apologies once again.

Thanks for your quick response.

[nagakavyasri]

Try this formula:

if ([PredCarrier]=[Air ff] && [PredCarrier]!= 'NULL')||([PredCarrier]!= 'NULL' && FINDSTRING([Program],[PredCarrier]) > -1) then 'Yes' else 'No' endif

[mmustkee]

Hi,

Result is not matching.

If you see your screen shot and refer record "6" Air FF is not as we have in predcarrier and Program.

The condition should be as below

Predcarrier = Air ff and then find in Program if matches then Yes else no