convert excel formula into Alteryx formula

[AvinashBhawsar]

Hi All,

I hope everyone is doing well. can anyone help me out to convert the below formulas into alteryx compatible.

=IF(D2="","",IF(OR(W2="Reconciled",W2="Timing Delays"),0,IF(AND(Q2="Same",R2>0),R2+1,IF(Q2="New",1,"ERROR"))))

D2 represent the column :- SellerLoanNum

W2 represent the column :- NOTES

Q2 represent the column :- Compare Notes)

R2 represent the column :- Prior Age

 =IF(A2="PASTE DATA HERE","",IF(ISNA(IF(P2=U2,"Same","New")),"",IF(P2=U2,"Same","New")))

A2 represent the column :- SellerId

P2 represent the column :- Prior Day Notes

U2 represent the column :- Breaks Check

Thanks for taking out time to read 

[Luke_C · Accepted solution]

@AvinashBhawsar Okay, since the field itself is text, you need to update the 0 and 1 like below

IF isempty([SellerLoanNum])
then [SellerLoanNum]
Elseif [NOTES] in ('Reconciled','Timing Delays')
Then '0'
Elseif [Compare Notes] = 'Same' AND [Prior Age] >0 
Then tostring([Prior Age] + 1)
Elseif [Compare Notes] = 'New'
Then '1'
Else null()
Endif

[AvinashBhawsar]

still the same, as soon as i enter endif it turns into black and not letting me end this.

[atcodedog05]

Hi @AvinashBhawsar 

Can you please provide sample input data in a file it would be easier and faster for us to work with and help you 🙂

[Luke_C]

@AvinashBhawsar you are missing the 'f' at the end of 'endif'

[AvinashBhawsar]

i did it but not working.

[Luke_C]

@AvinashBhawsar Please try the tostring([NOTES]) I mentioned earlier. Otherwise we'll need sample data and your workflow like @atcodedog05 mentioned. Thanks

[AvinashBhawsar]

@atcodedog05 @Luke_C  thanks for the help :) below is the same file for your reference.  i have manipulated the data due to confidentiality. you can change the notes to Reconciled or Timing Delay for testing purpose.  also can refer the current age column for the formula.

[Luke_C · Accepted solution]

Hi @AvinashBhawsar 

Formula I provided is working fine. please check. 

[atcodedog05]

Hi @AvinashBhawsar 

Here is how you can do it.

Workflow:

Hope this helps : )

[atcodedog05 · Accepted solution]

Hi @AvinashBhawsar 

Also when [SellerLoanNum] is empty instead of setting to [SellerLoanNum] you can set it to Null() since [SellerLoanNum] will also be empty/Null()

Hope this helps : )