How to get the Exact Mach using lookup range activity. For example i want to search for Policy ID column name. when i am using lookup range its giving results when " Policy " exists, but i want to check if Policy ID is available or not .Can you help me with this
hello @B_H_Akshatha_Pai thanks for answering the question. actually Excel Data is not starting from Row 1 it starts from row no 10 or 13 or it can be anywhere but not on starting row. So to find out the starting row i am searching for Column Name to identify the Starting row.
You can use find/Replace activity. You have options to match whole content which can be checked
@Anil_G Thanks for answering the question, but i want to check in Excel. Find/Replace can used within the string manipulations right?
Find/replace activity is there in excel as well
I hope you are on modern design
@Anil_G i m currently in classic design
Either follow 1 of the below two
- Activities → filter icon → modern …this shows the modern activites
- You can read the datatable and use lookup datatable and find the index and use in the excel