I have two excel sheets. One have a sheet called "Detailed Sold rev & backlog AUG" which has "Client Name (as per SUN / Salesforce)" in column F from row 6 (row 5 is header). Second excel file has a sheet called "Client wise data used" which has "Client name" in column A from A3. Column B3 has "sector" mentioned in it. "Client Name (as per SUN / Salesforce)" and "Client name" needs to be fuzzy matched and corresponding "sector" in the second excel file has to be recorded in the first excel file in column O from O6.
How can this be done through Alteryx
Could you please share the example datasets?