I'm trying to add up a quantity in a column, if the first column contains like numbers, also if another column contains a set number. As an example from the report I pulled, see below:
[TABLE="width: 310"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]Column B Column H
323 100579538[/TD]
[TD="align: right"]Col I [/TD]
[/TR]
[TR]
[TD="align: right"]323 100088098[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]323 100088214[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]323 100088222[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]323 100088277[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]323 100503009[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]323 100505300[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]323 100523351[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]323 100523884[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]323 100583204[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]323 100584112[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]323 100088371[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]323 100567650[/TD]
[TD="align: right"]682[/TD]
[/TR]
[TR]
[TD="align: right"]323 100503017[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD="align: right"]323 100511750[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]324 100517484[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD="align: right"]324 100517961[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]324 100088197[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]324 100583446[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]324 100579538[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]324 100579538[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]324 100046955[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]324 100513078[/TD]
[TD="align: right"]2[/TD]
[/TR]
</tbody>[/TABLE]
This didn't come over as a table, but it is three columns. Columns B, H, and I (Other columns are filled, but irrelevant information)
These columns are then sent to a new table, where I'm trying to accomplish the following:
Column B is a technician number, on this report of roughly 100,000 rows, there could be 100 or 150 unique numbers, for this example, I'm showing two numbers (323, and 324). Column H is a part number and these can be duplicated 10's of 1000's of times per report, and per technician number. Finally, column I is a quantity.
The way the report essentially works, Technician 323 uses part number X, Y times, rinse and repeat.
I'm trying to report this to a new table to show, the quantity of part X for each technician.
I want to declare a tech number, then it takes total quantity (I column counts) per part number.
To be clear on this, the report can be 100,000 rows, approximately 3000 unique part numbers (Column H), repeating at different intervals), and the total unique technician numbers is approx 100-150.
I hoping the output to just be a very simple:
Technician 323:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Part Number[/TD]
[TD]Quantity[/TD]
[/TR]
[TR]
[TD]100503021[/TD]
[TD]3 (Total Count of Column I for Part Number used by tech 323)[/TD]
[/TR]
[TR]
[TD]100511074[/TD]
[TD]7 (Total count of Column I for part number used by tech 323)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance
[TABLE="width: 310"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]Column B Column H
323 100579538[/TD]
[TD="align: right"]Col I [/TD]
[/TR]
[TR]
[TD="align: right"]323 100088098[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]323 100088214[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]323 100088222[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]323 100088277[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]323 100503009[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]323 100505300[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]323 100523351[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]323 100523884[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]323 100583204[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]323 100584112[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]323 100088371[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]323 100567650[/TD]
[TD="align: right"]682[/TD]
[/TR]
[TR]
[TD="align: right"]323 100503017[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD="align: right"]323 100511750[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]324 100517484[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD="align: right"]324 100517961[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]324 100088197[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]324 100583446[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]324 100579538[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]324 100579538[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]324 100046955[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]324 100513078[/TD]
[TD="align: right"]2[/TD]
[/TR]
</tbody>[/TABLE]
This didn't come over as a table, but it is three columns. Columns B, H, and I (Other columns are filled, but irrelevant information)
These columns are then sent to a new table, where I'm trying to accomplish the following:
Column B is a technician number, on this report of roughly 100,000 rows, there could be 100 or 150 unique numbers, for this example, I'm showing two numbers (323, and 324). Column H is a part number and these can be duplicated 10's of 1000's of times per report, and per technician number. Finally, column I is a quantity.
The way the report essentially works, Technician 323 uses part number X, Y times, rinse and repeat.
I'm trying to report this to a new table to show, the quantity of part X for each technician.
I want to declare a tech number, then it takes total quantity (I column counts) per part number.
To be clear on this, the report can be 100,000 rows, approximately 3000 unique part numbers (Column H), repeating at different intervals), and the total unique technician numbers is approx 100-150.
I hoping the output to just be a very simple:
Technician 323:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Part Number[/TD]
[TD]Quantity[/TD]
[/TR]
[TR]
[TD]100503021[/TD]
[TD]3 (Total Count of Column I for Part Number used by tech 323)[/TD]
[/TR]
[TR]
[TD]100511074[/TD]
[TD]7 (Total count of Column I for part number used by tech 323)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance