community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Impute Missing Data Values with a Custom Formula

Highlighted
Meteoroid

I have a specific use case for vehicles that are sold within a data set.  Does anyone have thoughts on a good way to go about identifying the dealers with vehicles (VIN's) in common from a data set?  My data set is millions of vehicles long but I'm wanting to find the most common combinations, whether Dealer A is selling to Dealer B or visa versa.  Here are the basic data points I would have.

 

sellerbuyerdateamountvin
Dealer ADealer B2/11/201910000123456
Dealer CDealer D3/15/201911000123456
Dealer CDealer D2/1/20195000567890
Dealer BDealer A3/1/201915000567890
Dealer BDealer A1/11/20194000456789
Dealer ADealer C2/15/20196500456789
Dealer ADealer B1/16/2019

8800654321
Dealer DDealer C3/1/201910000654321
Bolide

Hi @byagelski, would something like this work for you?

 

Help1.PNG

Meteoroid
Wow, very creative. This should work really well. Thank you @JoBen!
Labels