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

Vlookup/fuzzy match how?

Kucsi
8 - Asteroid

Hello Community!

 

I need your help in a very painful issue. 

 

I need to vlookup two input into one, both side has its own ID, but in the second input it's not the same ID. 

So ID != ID2. But ID = Contains([ID2], [ID]). 

 

I attached a workflow with the two input and the desired output. 

 

Thanks for the help!

Kucsi

4 REPLIES 4
gy_ch
5 - Atom

Hi you can assign record ID to both inputs and join them using a Join tool.

 

Hope this helps!

 

2019-03-14 21_08_29-Clipboard.png

2019-03-14 21_08_46-172.28.6.137.png

Kucsi
8 - Asteroid

Hi,

 

sorry my fault. Sadly in the report what is come from SAP and from banks, it's not sorted. It's randomly ordered :( So the recordID is not an option in this case :/ But thanks :)

estherb47
15 - Aurora
15 - Aurora

Hi @Kucsi 

You can Append all of the fields together and then use a filter for the Contains([ID2],[ID]) needs. Just be sure data types match too (the field is a number in one input and string in another, so I made them both V_WString)

Workflow attached as I can't paste pictures today.

Cheers!
Esther

Kucsi
8 - Asteroid

Hi EstherB47,

 

It works!! Thanks :)

 

Kucsi

Labels