I want to check 2 conditions in if condition

T_Y_Raju · February 12, 2021, 3:49pm

i want to check 2 conditions in Data table in one single if condition activity like row(“Status”)=“” and row(“Status”)=“Exception”

condition should check both the criteria in data table and then it should move

T_Y_Raju · February 12, 2021, 4:36pm

plz provide the solution

NIVED_NAMBIAR · February 12, 2021, 5:28pm

You can try the three ways

Steps to be followed

a. Read the excel and store in dt1

b. use for each row to loop through each row of dt1

iniside the for each row , use the if condition with condition as

row(“Status”).ToString=“” or row(“Status”).ToString=“Exception”

then do accordingly in the else and then section

OR

Steps to be followed

a. Read the excel and store in dt1

b. Use filter datatable activvity with below property values as in below image

OR

Steps to be followed

a. Read the excel and store in dt1
b. use assign activity

dt2 = dt1.AsEnumerable().Where(Function(row) row(“Status”).ToString.Equals(“”) Or row(“Status”).ToString.Equals(“Exception”)).CopyToDataTable

c. this will output with row having status null or exception

Hope it helps you

Mark it as solution if resolves your query

Regards
Nived N
Happy Automation

T_Y_Raju · February 12, 2021, 6:02pm

row(“Status”)=“” and row(“Status”)=“Exception” . de we have to use .tostring here

NIVED_NAMBIAR · February 12, 2021, 6:04pm

Yes u need use that too

Instead of and use or

I had updated my answer above please check

I forget to add that @T_Y_Raju

T_Y_Raju · February 18, 2021, 7:06pm

is dt2 is another data table i have to create…or just string variable i have to take

NIVED_NAMBIAR · February 18, 2021, 7:06pm

It is another datatable @T_Y_Raju