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: