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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Pick first value - similar to vlookup

Meteoroid

Hi,

 

There are 2 tables in my database. First table contains only DEA IDs. Second table contains 2 more columns along with DEA ID. if you see there are multiple IOD value for a single DEA. Now i want to add a column of IOD to my first table (with DEA only) but only pick the first IOD value from table 2.

Here is the snapshot of my data

Table 1

DEA
BZ8028335
BZ8813164
BZ9422279
F95771983

 

Table 2

IODPrimary DEAHIN
Medical PracticeBZ802833557YMXLE00
SON - Physician DispBZ802833557YMXLE00
Medical PracticeBZ8813164HBVT65R00
SON - Physician DispBZ8813164HBVT65R00
Medical PracticeBZ9422279BGEH8XR00
SON - Pharmacy DispF95771983FJEVB5N00

 

Result

DEAIOD
BZ8028335Medical Practice
BZ8813164Medical Practice
BZ9422279Medical Practice
F95771983SON - Pharmacy Disp

 

Alteryx Certified Partner

Hey @agoyal28

 

Before you join Table1 to Table2 put a summarize tool on the Table2 stream....Group By Primary DEA and choose "First" IOD

Quasar

Here is the sample workflow for your case. Hope this is helpful. 

 

workflow.PNGWorkflow

Labels