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

Vlookup

Asteroid

Hello!

I have 3 tables and I need to vlookup from the 2 circle and from the 3 hours. The table3 is the first priority. So if I found hours I don't need circle. The last column "time" put not empty rows of columns "Hours" and "Circle" 

Table 1

RouteDetailRoute+PointHoursCircleTime
301

D1

301D12 2
302D2302D23 3
303D3303D3 44
304D4304D49 9

 

Table 2 - Circle

RouteCircle
3015
3026
3034

 

Table 3 - Hours

Route+PointHours
301D12
302D2
304D49

 

Thanks a lot !!!

Alteryx Certified Partner
Alteryx Certified Partner

Well, I think you should take a look at the Join tool and how that tool works, it allows you to perform the lookups you have identified. The only complexity is the logic for finding unmatched records on your first join with table 3. You should look at the L and R output streams for the join tool to identify the records that don't match. Then you can use those to join against the table 2.

 

The union tool is likely to be useful in this case! Please have a try and explore the tools available, and let us know where you get stuck after you have made an attempt.

 

Ben

Labels