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
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
please use trimstart and trim end as there may be spaces at both the start and end of the string
Thanks and Regards.