Condition is not working properly

Help
, ,
1

I need to check two excel files, here i am using if condition activity or flow decision activity. but it’s not working properly if satisfy true, it always goes to the false side.
Kindly suggest some solution.

Thank U.

2 Likes
2

@Kalees9486.
Can you ping me your condition or the XAML File

1 Like
3

Hi buddy @Kalees9486
Kindly provide the if condition you used buddy
Cheers

4

row(1).ToString.Trim = row1(6).ToString.Trim
Incase I assign some values like yes or no in, if and else condition, it will always lead to else part. @Palaniyappan @Vijay_Tulsalkar

1 Like
5

Buddy kindly check the column index once buddy
your condition looks correct may be if you want we can put like
row(1).ToString.Trim.Equals(row1(6).ToString.Trim)

Cheers @Kalees9486

6

@Kalees9486

Did you check for the case sensitivity ? like row(1).ToString.Trim.tolower = row1(6).ToString.Trim. tolower

1 Like
7

Yeah, i checked.its correct only

1 Like
8

its same only

1 Like
9

@Kalees9486

Before checking condition try to print those values and see.

1 Like
10

Fine buddy @Kalees9486
is there any hidden column or filter applied to that column
kindly check once with the value by printing them with WRITE LINE ACTIVITY buddy inside both of the for each row loop and check the length of each string from the row buddy
Cheers @Kalees9486

11

Yeah, that also i checked and printed.i got the correct output as i expected. but i am writing the same output in excel it appends wrong value.

1 Like
12

No hidden or filtered columns.its like normal excel only. @Palaniyappan

1 Like
13

check whether the number of columns are same buddy
in both the tables as you are using append range activity @Kalees9486

14

@Kalees9486

If possible could you please create some sample data with that original files and share with me.Will check and update you.

1 Like
15

@Kalees9486

Share your XAML and files .

1 Like
16

Ok,but if excel columns are not in same, then how will i get correct output n Uipath console?

1 Like
17

Flowchart.xaml (36.0 KB)

PFA,

1 Like
18

@Kalees9486

I did not find any IF condition in your workflow.

1 Like
19

In flow decision buddy @lakshman

20

i think we need to check with the data…workflow looks good
i mean what was the error you were facing actually buddy, you said condition is not matching
is wrong is entered after mismatch or no data is entered to the datatable after the validation
Cheers @Kalees9486