Data matching

Question

Hi Everyone,

Hope you are doing well.

I am facing issue with data matching.

I have data in input file 1 which needs to be look up in input 2 and final out should be given format. The format can't be altered.

I am able to solve a part of the ask however i am unable to handle the exceptions present in the input 1.

please advise.

Regards

Dev

input 1.PNG

input 2.PNG

output.PNG

New Workflow3.yxmd

Emil_Kos · Accepted Answer

Hi @Devsadhan86,

I have prepared a workflow for you.

I have a super small difference in the final output. Between / and WMBG I don't have additional space. Please let me know if this is acceptable for you.

The main difference is I have used replace method + replace multiple found items.

The workflow:

Please mark my post as a solution if this was helpful.