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

[gy_ch]

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

Hope this helps!

[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 · Accepted solution]

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]

Hi EstherB47,

It works!! Thanks :)

Kucsi