The result doesn't agree with the condition

Help
, ,
1

image

The result doesn’t agree with the condition. How can I solve this?

2 Likes
2

Try this : in_rowcount.ToString.Contains(“On Leave”)

2 Likes
3

Thank you but I still come up with the same result. Is there any other solution?

1 Like
4

Hi , you need to use for each row loop , to validate the values of columns
For the read range , the output will be datatable variable ex:DT1
Now use for each row activity
For each row of DT1
Inside for each row body
Use get row item activity and give column name at column name property
Output will be a string variable ex:str1

Now use if condition as in your screenshot

2 Likes
5

i’m sorry, it’s my bad, you need use for each row activity if you use Read range to read Excel file. You maybe also use read column activity instead.
Eg:Capture

1 Like
6

@ROBERT_RUSSELL_MONSA

Hi.

I think there is a misunderstanding between you and the respondent.
I saw your previous question. If this question is a continuation, it is recommended that you publish information such as variable types. Or you may need to explain in detail what you want to do.

Thanks.
-Tera

1 Like
7

The result is still “Not Absent”.

1 Like
8

Can you share your Excel file for me ?

9

I’m sorry but the Excel File is confidential.

10

Hi @ROBERT_RUSSELL_MONSA, my workflow is here, you can check it:
Main.xaml (6.9 KB)

1 Like
11

Thank you so much.

1 Like
12

It’s nothing, wish you happy with your Job.

1 Like
13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.