Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Type Mapping for each company

SH_94
11 - Bolide

Dear community,

 

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

 

Input 1

 

part 1.jpeg

 

Input 2

 

part 2.jpeg

 

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

part 3.jpeg

 

 

4 REPLIES 4
Bluebird_Tim
7 - Meteor

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
20 - Arcturus
20 - Arcturus

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

 

0829-SH_94.png

Bluebird_Tim
7 - Meteor

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

SH_94
11 - Bolide

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

 

 

Labels