Join data if time between (Vlookup)

Question

Hello,

im new to alteryx and have an issue.

I want to "join" Names to a specific time Value.

In Excel i would do an Simple  =Vlookup(D3;$A$3:$B$5;2)

Here the Example:

Is there a way to get the result with alteryx?

If you need any further information just ask. 🙂

Thanks for your advice

Greetings.

Vlookup.xlsx

andyuttley · Accepted Answer

hi @Terades

There's a few ways to do this; my initial approach was to answer it using an iterative macro that works backwards through your file, as shown below (also attached):

Like i say though, there's a few ways to tackle this; this is just one approach.

Hope that helps

Andy

klyuka · Accepted Answer

Alteryx has SQL logic like Access (tables like objects), not Excel (cells like object) - it helps to make it faster and object-oriented.

But you need to change your view on data management.

Alteryx need always a tricky mind to find new solutions, but I think that every man that is hired to use Alteryx (not a cheap toy) should have a good logical mindset.

Easy (fast result) - to merge two lists and take what you want (this work only if not more than 16 rows in Table A. Algorhythm difficulty - O(A*B)

Correct solution (critical for big data management) - sort Table A and Table B, use Multi-Row Formula tool and create logical formulas with difficulty - O(A+B).

Alex