Unable to write status data in Output column

studio
variable

#1

Hello All,

I have a scenario where I need to check the below condition and publish the result in the output column of the excel, but after fulfilling the condition too , i am unable to do the same.
Please help.
My condition is ,

If age < 30 and address is not able or age > 30 and phone no is not available then output column should be fill as Fail.
Else if all the three data are available say suppose age = 30, address is also available & Phone No is also available, the output should be Pass.

I am using the condition as ,
checkAge<30 and checkAddress=Nothing or checkAge>30 and checkPhone=Nothing

Thanks,
Sumit


#2

@sumitkr1118

what error you are getting.

Regards,
Mahesh


#3

I am unable to get the proper result in the output column. Say for the third condition it should populate the result as Pass in the output column but i am not getting the result as expected.


#4

@sumitkr1118
try this,
you should not miss the brackets.

(Convert.ToInt32(age_Variable.ToString)<30 and checkAddress_variable.ToString.ToUpper.Equals(“NOTHING”)) or (Convert.ToInt32(age_Variable.ToString)>30 and checkPhone_variable.ToString.ToUpper.Equals(“NOTHING”))

Regards,
Mahesh


#5

test.xaml (9.7 KB)
test.xlsx (8.1 KB)

Please refer my approach and excel file.
Please inform me what are the changes i need to do with my existing file.

Thanks,
Sumit


#6

@sumitkr1118
I have made some modifications and its working fine according to your requirement. just go through the xaml.
test.xaml (14.2 KB)

Regards,
Mahesh


#7

Thanks Mahesh.
It’s working perfectly :slight_smile:

Regards,
Sumit