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
