I have a challenge at work where I need to take a list of vendors, which contains a significant amount of duplicates, create a distinct table of vendors and within that table have a column that has the total quantity supplied by the vendor. Here is an example data set below:
Vendor Name
QTY Supplied
Vendor A
5
Vendor A
3
Vendor A
1
Vendor B
2
Vendor B
3
Vendor B
1
Vendor C
7
Vendor D
2
I need a table created that looks like the following:
Unique Vendor Name
Total QTY Supplied
Vendor A
9
Vendor B
6
Vendor C
7
Vendor D
2
So far, I've created the distinct table of vendors by using LOAD DISTINCT [XXXX] from the source, but I am not sure how to handle getting the total QTY column generated from the original data set to tie into my distinct table.
