Type Mapping for each company

[SH_94]

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

[Bluebird_Tim]

Hi @SH_94 !  Give this a shot.  Probably some unnecessary sorts in there but helped me along the way :)

For the record APASS12 I presumed you wanted to leave blank so I took care of that in the formula tool.  Also used a data cleanse just to normalize the null

Let me know if this helps and marked solved if so :D   

Feel free to ask any other questions!

[Qiu]

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

[Bluebird_Tim]

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

[SH_94]

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