How to write Multiple "if" Conditions with out Using "Nested-if"

[adarsh_kotagiri]

Hello Every one,

This is my input Data

Each and every row Satisfies the Four Conditions As shown Below

1. Aa <>“NA” & Bb <>“NA” & Cc <> “NA” & Dd =“NA” ; Result=“SA+LOAN”
2. Aa <>“NA” & Bb =“NA” & Cc = “NA” & Dd <>“NA” ; Result=“CC+LOAN”
3. Aa <>“NA” & Bb <>“NA” & Cc <> “NA” & Dd <>“NA” ; Result=“SA”
4. Aa <>“NA” & Bb =“NA” & Cc <> “NA” & Dd <>“NA” ; Result=“LOAN”

Output-

Here I am Using Nested If as shown Below

But i need to write this if Conditions by using Invoke Code or Linq. How to do that

My file-
IF_Condition_Exmpl.zip (9.8 KB)

Thanks
Regards,
Adarsh.

[Boopathi.M]

Hi @adarsh_kotagiri

We can use multiple “if” in assign activity ternary operator logic, modified the xaml you attached. Check if it works for you.

If no condition is met, string.empty will be displayed orelse you can give your default value.

IF_Condition_Exmpl_Modified.zip (10.7 KB)

Thanks,

[ppr (Peter Preuss)]

We can use a switch by simulating a bit mask

Building Block:

with the configured arrColset we build up the BIT Mask as String and will use it within a switch

Sample Data:

gives following output:

Find Starter help here:
Demo_CheckMask_Switch_4Cols.xaml (9.6 KB)

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @adarsh_kotagiri,

In this case, you can either go for using flow decisions in a flowchart or you can for using switch activity as suggested by @ppr also.

Regards
Sonali

[adarsh_kotagiri]

Thank you so much @ppr For creating the work flow its really working … i learned something new .

[adarsh_kotagiri]

Thank you so much @Boopathi.M its wroking too…