Hello,
From the below table I need a simple output.
There are ID's assigned to each item. If the item type and ID's are same the output should be 'TRUE" else "FALSE"
Example - ID 1000024 has all the same item type so the output should be "true" whereas ID 1000025 different item type it should be "FALSE"
<tbody>
</tbody>
From the below table I need a simple output.
There are ID's assigned to each item. If the item type and ID's are same the output should be 'TRUE" else "FALSE"
Example - ID 1000024 has all the same item type so the output should be "true" whereas ID 1000025 different item type it should be "FALSE"
ID | ITEM TYPE | OUTPUT |
1000024 | CONSUMABLE | |
1000024 | CONSUMABLE | |
1000024 | CONSUMABLE | |
1000024 | CONSUMABLE | |
1000024 | CONSUMABLE | |
1000025 | CONSUMABLE | |
1000025 | CONSUMABLE | |
1000025 | CONSUMABLE | |
1000025 | REPAIRABLE | |
1000025 | EXPENDABLE | |
1000025 | CONSUMABLE |
<tbody>
</tbody>