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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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