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
Solved! Go to Solution.
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 :)
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
Hi EstherB47,
It works!! Thanks :)
Kucsi