Hi Team
I am looking for help in getting require category mapping based on multiple conditions....
Here is the Dataset ...
<tbody>
</tbody>
Mapping
<tbody>
</tbody>
Require output based mappings table condition
<tbody>
</tbody>
I am looking for help in getting require category mapping based on multiple conditions....
Here is the Dataset ...
| Product | Price | Region |
| P-1 | 360 | N |
| P-2 | 347 | N |
| P-3 | 452 | S |
| P-4 | 179 | S |
| P-1 | 345 | E |
| P-2 | 274 | W |
| P-3 | 207 | E |
| P-4 | 177 | E |
| P-5 | 177 | E |
<tbody>
</tbody>
Mapping
| Product | Region | Category |
| P-1 | N | Category 1 |
| P-2 | S | Category 1 |
| P-3 | S | Category 2 |
| P-5 | N | Category 2 |
| P-4 | E | Category 2 |
<tbody>
</tbody>
Require output based mappings table condition
| Product | Price | Region | Category |
| P-1 | 360 | N | Category 1 |
| P-2 | 347 | N | NA |
| P-3 | 452 | S | Category 2 |
| P-4 | 179 | S | NA |
| P-1 | 345 | E | NA |
| P-2 | 274 | W | NA |
| P-3 | 207 | E | NA |
| P-4 | 177 | E | Category 2 |
| P-5 | 177 | E | NA |
<tbody>
</tbody>
Last edited:
