IF CONDITION IN ASSIGN ACTIVITY

[ldiaz (Leonardo Diaz)]

HELLO . how can i make conditions in assign that validated if the column is contain specific value and empty. if the column is contains the value or empty do nothing if not contains na value copy the other row value

[kennbalobalo (Kenneth Balobalo)]

hi @ldiaz,

Would it be better to put an If activity and then assigns the values on the Assign activity accordingly?

If not, then the syntax to be passed on the Assign activity would be: If(expression, true return, false return)

[Sudharsan_Ka]

HI @ldiaz

Check with this expression

If(FindRow("ACCOUNT TYPE").Tostring.Contains("CREDIT CARD"),"",FindRow(4).Tostring)

Regards
Sudharsan

[RajKumar_DC (RajKumar Durai)]

Hi @ldiaz ,

find below conditions

If(FindRow(“ACCOUNT TYPE”).Tostring.Contains(“CREDIT CARD”) and String.IsNullOrEmpty(FindRow(“ACCOUNT TYPE”).Tostring),Nothing,FindRow(4).Tostring)

If(FindRow(“ACCOUNT TYPE”).Tostring.Contains(“CREDIT CARD”) or String.IsNullOrEmpty(FindRow(“ACCOUNT TYPE”).Tostring),Nothing,FindRow(4).Tostring)

Thanks,
Rajkumar

[Sudharsan_Ka]

Also you can try with this @ldiaz

if(String.IsNullOrEmpty(FindRow("ACCOUNT TYPE").Tostring) Or FindRow("ACCOUNT TYPE").Tostring.Contains("CREDIT CARD"),Nothing,FindRow(4).ToSTring)

Regards
Sudharsan