Alteryx Designer Desktop

Get started with Alteryx Designer Desktop.

Data cleansing

Bong01
5 - Atom
 
 

Hi Everyone,

 

May I ask your assistance on the table attached, what I want to achieve are the following

1. Scenario: address 1, 2 and 3 = FR

Output = FR

2. Scenario: Address1 and 2 = FR, address3 = MC

Output = FR, MC

3. Scenario: address1 = FR address2 = AE and address3 = MC

Output = FR, AE, MC

4. Scenario: address1 = FR, address2 = FR and address3 = blank

Output = FR

5. Scenario: address1 = FR, address2 = blank and address3 = US

Output = FR, US

6. Scenario: address1 = FR and address2 and 3 = blank

Output = FR

 

Thank you in advance,

 

Bong01

 

 

 

 

 

0 REPLIES 0