If with right nested

Jon_21381

Hello 

Is there any way to get the function to work in data watch

=IF(LEFT(Loan,3)="000",RIGHT(Loan,7),IF(LEFT(Loan,2)="00",RIGHT(Loan,8),0))

Thanks

------------------------------
Jon Pernice

------------------------------

lekha janardhan

Hello Jon,

You can create your own function in the Monarch data prep studio based on your requirement for the particular column..

just click the dropdown in the particular column >column>new formula column> choose if(,,) function..

 

Please go through the attached sample document...

Thank you

Lekha J 

 

Community-Pasted-Attachment-1613025494677.png

Moarch_new_col.PNG