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
Solved! Go to Solution.
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.