Hello,
I would like to take the following data:
SKU | anatomy2 | Sum_sales |
@804-03-021 | KNEE | 323 |
@804-03-021 | SHOULDER | 2,040 |
@506-03-138 | SHOULDER | 154,922 |
@506-03-138 | KNEE | 523 |
@520-50-220 | SHOULDER | 317,531 |
@520-50-220 | KNEE | 900 |
and take the largest sales value and use it to determine which anatomy should be used for the SKU:
SKU | anatomy2 |
@804-03-021 | SHOULDER |
@506-03-138 | SHOULDER |
@520-50-220 | SHOULDER |
Solved! Go to Solution.
@Erick_Reyes101 The first thing I did was clean up the Sum_sales field. Because it has commas in it, it came in as a String with leading spaces. I used a Formula tool with this expression to trim and remove commas: Replace(Trim([ Sum_sales ]), ',', ''). After that, I used a Select tool to change the data type of Sum_sales to Int32, sorted descending on Sum_sales, then used the Sample tool to select First 1 why grouping on SKU.
@Erick_Reyes101 Another method
thanks to you both!
i think both would work for my problem, thanks for the help!