title: Multiple (fuzzy) joins in a single query?
body: <p>I am experimenting with the Fuzzy Join capability in PQ (Excel for O365 64 bit)</p>
  
  <p>A single join using Table.FuzzyNestedJoin() works as expected. However the behaviour of the "tweakable" parameters on the fuzzy join such as the match quality and transformation table aren't always easy to predict.</p>
  
  <p>What I would like to do is perform the same join multiple times with varying parameters, and see the results side by side. Given source data like-</p>
  
  <pre><code>Table A                           Table B
  =======                           =======
  First     Last                    First     Last
  -----     ----                    -----     ----
  Jane      Johnson                 Jane      Johnson 
  John      Johnson                 Joan      Johansen
  Jim       Johnson                 James     johnson
  Jimbo     Janssen                 Janey     Jamieson
  ...                               ...
  </code></pre>
  
  <p>I'd like to create a result table like-</p>
  
  <pre><code>                      (80% match)        (90% match)
  First     Last        First80 Last80    First90 Last90
  -----     ----        ------- -------   ------- ------
  Jane      Johnson     Jane    Johnson   Jane    Johnson
  John      Johnson     Jane    Johnson 
  Jim       Johnson     James   Johnson   James   Johnson
  Jimbo     Janssen     Jim     Johnson
  ...                   ...               ...
  </code></pre>
  
  <p>However if you just add multiple fuzzy merge steps to a query using the UI, each Fuzzy join result replaces the last, so there is only ever one new result column (containing the nested table of match results)</p>
  
  <p>Although the documentation for Table.FuzzyNestedJoin says a new column is created for the result, just renaming the output column in subsequent Joins doesn't prevent each one from removing the previous one.</p>
  
  <p>So- is there a way of achieving multiple Fuzzy Joins in a single query, or is the only option to produce a chain of tables along the lines of-</p>
  
  <pre><code>Join/Merge Tables A, B to produce Table AB
    Join AB to C to produce ABC
      Join ABC to D to produce final result ABCD
  </code></pre>