Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Join and select first value instead of creating duplicate records

AW25
7 - Meteor

Hello!

 

I have a set of unique Loan Numbers with loan details that I wrote to a table in SQL (through Alteryx). I'm joining that table to a 2nd table to pull in borrower names. The issue I have is that the 2nd table sometimes has the same loan number listed multiple times and the names vary slightly in each one. It doesn't matter to me which name is pulled in because the name is just a reference for the end-user of this workflow but when I join the tables, Alteryx creates multiple rows for the loan numbers that show up multiple times in the 2nd table. I've seen some solutions where the problem is like Sales Orders with Dollar Amounts and it aggregates the dollar amounts so you end up with unique values for the Sales Order but I don't want to merge multiple instances of the names together, I just want it to pick one and move on to the next step.

 

Any suggestions? Thanks in advance!

 

 

Loan Table 1 that I want to bring in Borrower Names to:

Input1.png

 


Loan Table 2 with the Borrower Names:

Input2.png

 

 

Current Output Table that creates multiple duplicate records:

Input3.png

 

3 REPLIES 3
dataMack
12 - Quasar

This solution was collectively sourced by the Philly user group live...

 

We suggest a couple of approaches:

(1) A unique tool placed after the borrower table and select unique on the loan number

 solutionUnique.png

(2) A group by on Loan number via a summary tool and pick a function like First for the names

 

(3) Sample tool using a group by on loan number

AW25
7 - Meteor

That worked! Thanks Philly!

TuvyL
Alteryx Alumni (Retired)
Amazing teamwork!!
Tuvy Le
Manager, Community ACE Program
Labels