Forum Discussion

J-Ash's avatar
J-Ash
Copper Contributor
Nov 17, 2020

Fuzzy match-output/match columns not loading

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.
excel
adversi's avatar
adversi
Iron Contributor
Nov 17, 2020

J-Ash 

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

  • J-Ash's avatar
    J-Ash
    Copper Contributor
    Nov 17, 2020

    Actually, it just started working.  I don't know why it wouldn't load before.  Thank you!

     

     

     

     

    • blnh-extr's avatar
      blnh-extr
      Copper Contributor
      Dec 12, 2023

      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.

Resources