Fuzzy Grouping - Canonical Row RRS feed

  • Question

  • Hi,

    I have two data sources - an Excel Worksheet and an existing table(Table1) which I union together and populate Table2.

    I then perform a Fuzzy Grouping on Table2 to identify matching rows.

    If a match is found I want the canonical row / pivot row to be that from Table1 and not the row which came into Table2 from the Worksheet.

    Is this possible or do I need to write my own matching code for this?

    Any advice appreciated.

    Thanks in Advance,


    Thursday, September 11, 2014 3:31 PM


All replies