Nov 17 2020 07:14 AM
I added Fuzzy Match to excel, but the match/output columns won't load. Is there something I need to do under configure? It works, but brings in all columns from both sheets.
Nov 17 2020 07:45 AM
The image is not displaying the entire options, but here is a checklist of what's needed:
1. Make sure both datasets are converted to tables
2. A link exists under Matched Columns for the lookup, you would need to click on the column names and then click on the center button
3. Control what columns are returned in the Output Columns and the threshold below
Nov 17 2020 08:15 AM
Actually, it just started working. I don't know why it wouldn't load before. Thank you!
Dec 12 2023 11:48 AM
@J-Ash I added a column to the second table. Fuzzy Lookup wasn't recognizing the new column. I closed and re-opened the file and the new column was there. I think Excel cache has something to do with why new columns aren't recognized unless you close the file and re-open.