Type Mapping for each company

Question

Dear community,

I would like to ask how do we build the workflow below with the two input below :

Input 1

Input 2

The criteria is if the text contain the mapping, then populate the mapping field information, if there is no information, then leave it empty. Each company will have their own text and they need to match it to mapping field

Output below

Text Mapping.xlsx

SH_94 · Answer

Hi @Qiu ,

Thnak you for the prompt response. I have the case whereby different company code have different mapping.May i know how to solve in this case?

For example

Input 1

Company Code     Mapping

AA00                     Checking

BB01                     Check

Input 2

Company Code     Text

AA00                     Check it done

BB01                     Let Check

Output

Company Code     Text                        Mapping

AA00                     Check it done

BB01                     Let Check               Check

Thank you

Bluebird_Tim · Answer

@Qiu Love this. Way simpler than my approach! 😂

Qiu · Answer

@SH_94 
This should be a perfect application for Find and Replace Tool. 😁

0829-SH_94.yxmd