Hi everyone, I have 2 excel sheets. 1 containing customer data like name, email address and favourite artist. While the other is the list of artist. I was wondering how I could compare the 2 excel sheets to check if a customer’s favourite artist is in the artist list and if it does, prompt a message box saying ‘(customer name) favourite artist, (artist name), is in our list’
I have tried using a for loop but I got confused how I could get the variables out of the excel sheet and properly promt the message box with the required variables. Any help is appreciated !
→ Use the read range workbook activity to read the First excel which the Customer data and favourite list and store the output in dt1.
→ Use another read range workbook activity to read the Second excel which has the list of artist names and store the output in dt2.
→ Take an assign activity and create a List of String variable called List_Artists.
→ After assign insert an for each row in datatable activity to iterate the each row in the dt1.
→ Inside for each insert If activity to check the condition.
