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

Impute Missing Data Values with a Custom Formula

byagelski
8 - Asteroid

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
2 REPLIES 2
JoBen
11 - Bolide

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

 

Help1.PNG

byagelski
8 - Asteroid
Wow, very creative. This should work really well. Thank you @JoBen!
Labels