Solved! Go to Solution.
HI Adam, I have the same issue but have run into problems using this Summarize solution.
So I have 100K rows of Part numbers and many of them are duplicates that have different pc prices.
I need alteryx to merge the duplicate records so each part number has only one row, and then give me the avg price.
For Example:
In my bill of material the same part number can be listed 100 times with a different price...
I need them to somehow merge and then avg the price -
(So that each Part Number will only appear on one line in the output with the avg price calculated in another column)
I can group by part number and then avg the price in the Summarize tool but then
I cannot get all the data from the original flow to pull through to the other side of the Summarize tool.
Do I need to group the Part Numbers first somehow? because I cant seem to get the Formula tool to do this either.
So far all I can find is info on how to Avg fields/columns - not records/rows.
Any Suggestions are welcome. I have been spinning my wheels on this for too long.
Laurie
Laurie,
If I'm understanding your issue correctly, you just need to bring in a Join tool.
Connect your summarized data on one side and your detailed data on the other side and join on the basis of the part number.
This will add the average cost column to your detailed data.
Then not sure if this is a requirement, but if you only want to end up with one record for each part number, you can add a Unique tool after the Join, select the part number as the unique identifier, and the first record will come through the "U" side with everything else going to the "D" side. You can then use a Select to determine what resulting columns you want to remain (e.g., you would eliminate the original price column that you summarized since it is now meaningless).