Fuzzy match-output/match columns not loading

%3CLINGO-SUB%20id%3D%22lingo-sub-1895666%22%20slang%3D%22en-US%22%3EFuzzy%20match-output%2Fmatch%20columns%20not%20loading%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1895666%22%20slang%3D%22en-US%22%3E%3CP%3EI%20added%20Fuzzy%20Match%20to%20excel%2C%20but%20the%20match%2Foutput%20columns%20won't%20load.%26nbsp%3B%20Is%20there%20something%20I%20need%20to%20do%20under%20configure%3F%26nbsp%3B%20It%20works%2C%20but%20brings%20in%20all%20columns%20from%20both%20sheets.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1895666%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1895807%22%20slang%3D%22en-US%22%3ERe%3A%20Fuzzy%20match-output%2Fmatch%20columns%20not%20loading%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1895807%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F871833%22%20target%3D%22_blank%22%3E%40J-Ash%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20image%20is%20not%20displaying%20the%20entire%20options%2C%20but%20here%20is%20a%20checklist%20of%20what's%20needed%3A%3C%2FP%3E%3CP%3E1.%20Make%20sure%20both%20datasets%20are%20converted%20to%20tables%3C%2FP%3E%3CP%3E2.%20A%20link%20exists%20under%20Matched%20Columns%20for%20the%20lookup%2C%20you%20would%20need%20to%20click%20on%20the%20column%20names%20and%20then%20click%20on%20the%20center%20button%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22adversi_0-1605627880139.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F234142i5499BA35C78F1167%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22adversi_0-1605627880139.png%22%20alt%3D%22adversi_0-1605627880139.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E3.%20Control%20what%20columns%20are%20returned%20in%20the%20Output%20Columns%20and%20the%20threshold%20below%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

2 Replies

@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

adversi_0-1605627880139.png

3. Control what columns are returned in the Output Columns and the threshold below

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