While debugging I am getting that my condition is false , Can someone please tell me whats wrong in this condition below: row1(2).Equals(row(0)) and (row1(14).ToString like decisionCond)

Learn Academy Feedback
1

while debugging I am getting that my condition is false , Can someone please tell me whats wrong in this condition below:
row1(2).Equals(row(0)) and (row1(14).ToString like decisionCond)
here row1 and row indicates 2 different excel sheet.

2

Hi @Chandni,
I’m not sure but if your rows are having more than one cell you can’t just compare them to each other. You can only compare one element to another but not element consist of many item inside. Probably you need to use loop to compare each element with corresponding element in second sheet one by one.

3

Hi Pablito, actually I am using this condition under for each loop , but I am not sure why this condition is not giving me desired output.

4

What exactly are you looping through? Cause if you are doing loop through rows it will still not working. You need to loop through each cell/column in your row and compare each particular element with corresponding element from second sheet.