Vlookup/fuzzy match how?

Kucsi

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

fuzzy-match-vlookup-issue.yxmd

Workflow

Fuzzy Match

Join

Accepted answers

estherb47

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

fuzzy-match-vlookup-issue.yxmd

All comments

gy_ch

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

fuzzy-match-vlookup-issue.yxmd

Kucsi

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

fuzzy-match-vlookup-issue.yxmd

Kucsi

Hi EstherB47,

It works!! Thanks

Kucsi

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703