Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Regarding joins in Ateryx

Tharashasank
8 - Asteroid

Hi All,

 

I have data  two data sets . please look into below.

Dataset1

Product idError message
1Product A is mandatory
2product b is mandatory
3product A@-b1 is invalid
3Product BX-11 is invalid
4Product CCzwertyu515 is not maintained for sales area O O 851000120
5product BZXzwertyu515 is not maintained for sales area O 851000120
6 
7 

 

 

Dataset2:

Error category
Product  (item name) is mandatory
Product  (series name) is invalid
Product (series) is not maintained for sales area (series)

 

I want to join both these Data sets  on Error message field and Error category field when i join this i need to get the below table as output:

Product idError messageerror category
1Product A is mandatoryProduct  (item name) is mandatory
2product b is mandatoryProduct  (item name) is mandatory
3product A@-b1 is invalidProduct  (series name) is invalid
3Product BX-11 is invalidProduct  (series name) is invalid
4Product CCzwertyu515 is not maintained for sales area O O 851000120Product (series) is not maintained for sales area (series)
5product BZXzwertyu515 is not maintained for sales area O 851000120

Product (series) is not maintained for sales area (series)

 

6  
7  

 

 

Please help me to solve this .

 

Thanks,

Tharashasank

 

7 REPLIES 7
Tharashasank
8 - Asteroid

Hi https://community.alteryx.com/t5/user/viewprofilepage/user-id/2690,

can you help me on the above request:

 

Thanks,

Tharashasank

GavinAttard
11 - Bolide

HI

 

Split the dataset 1 stream using 2 filters on column 2 for 2 of the 3 keywords; 'mandatory', 'invalid', 'maintained'. 

Append the respective record from dataset 2 either by using a lookup table or using the same filter method to align. 

 

done

 

Alteryx Everything, Leave no one behind.
Tharashasank
8 - Asteroid

Hi GavinAttard,

 

Thanks for your reply. Can you Please share a workflow.

 

Thanks,

Tharashasank

 

 

Tharashasank
8 - Asteroid

HI,

 

Can anyone provide an solution for the above scenario.

 

Thanks,

Tharashasank

JoeM
Alteryx Alumni (Retired)

Please see my attached solution.

 

Tharashasank
8 - Asteroid

Hi,

 

Thanks for the solution. I have a small doubt  if i want to show the values which are having empty values for error message in final set  . how i can get them.

JoeM
Alteryx Alumni (Retired)

@Tharashasank

Sorry, I didn't include them as part of the question because I thought they were mistakenly added. Attached is my updated solution.

Labels