When Comparing this two name using if activity its not matching, I dont know the reason why?

Please do suggest a method to resolve it
new.xlsx (8.4 KB) I have attached the excel file. plase do comapre both by using for each for two columns inside that use if activity to compare both column names

trim the values within the if


when you check the excel, some cols do have a space on the end which would let fail a strict check

show us more details e.g the immediate panel output for this two Variables
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

@Gopikrishna_S In Account Name column after each name there is a space so condition is getting false

Hi @Gopikrishna_S

How about this expression?

Dt.AsEnumerable().Select(Function (a)  CurrentRow("Customer Name").ToString.Contains(CurrentRow("Account Name").ToString)).Any


this two Columns are from two different excel so I will use two data table and used two for each loop one inside the other

Hi @Gopikrishna_S

Have a look on the workflow

CompareColumn.xaml (9.6 KB)


Hi @Gopikrishna_S
please use trimstart and trim end as there may be spaces at both the start and end of the string
Thanks and Regards.