Regarding joins in Ateryx

[Tharashasank]

Hi All,

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

Dataset1

Product id	Error message
1	Product A is mandatory
2	product b is mandatory
3	product A@-b1 is invalid
3	Product BX-11 is invalid
4	Product CCzwertyu515 is not maintained for sales area O O 851000120
5	product 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 id	Error message	error category
1	Product A is mandatory	Product  (item name) is mandatory
2	product b is mandatory	Product  (item name) is mandatory
3	product A@-b1 is invalid	Product  (series name) is invalid
3	Product BX-11 is invalid	Product  (series name) is invalid
4	Product CCzwertyu515 is not maintained for sales area O O 851000120	Product (series) is not maintained for sales area (series)
5	product 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

[Tharashasank]

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

can you help me on the above request:

Thanks,

Tharashasank

[GavinAttard]

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

[Tharashasank]

Hi GavinAttard,

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

Thanks,

Tharashasank

[Tharashasank]

HI,

Can anyone provide an solution for the above scenario.

Thanks,

Tharashasank

[JoeM · Accepted solution]

Please see my attached solution.

[Tharashasank]

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 · Accepted solution]

@Tharashasank

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