Hope you had a great weekend.
Here I am with a new set of problem.
I have attached an excel with this email with the data set.
The problem is
I have duplicate item Id. So how do I remove the duplicates?. My final aim is to total the Design - Create date and count the unique Item Id and then find the average.
But here because of the duplicate item ID, I also have extra amount in my total. How do i remove the duplicates and there influence in the total.
Thanks a lot,
Solved! Go to Solution.
Thanks for the solution.
But I am reading them from QVDs.
The problem actually started this way,
I had several Modified Date for the same "stage" of the Item in the data model. Stage,here are like pending stage, design stage etc.
But my user is actually using the last. modified date. So I loaded the max(Modified Date) with the Item Id, which suppossedly should have given me single records for each item, but now it seems that even max(modified date) is repeating.
Could you please explain,
What your code will do? I understand that it will pick the item and the maximum of the difference.
Because I don't have a field called Design-Create Date in the model.
I have made that field in this excel just to explain my problem.
I am sorry, if that lead you astray.
This code will calculate the Maximum DesingCreate Date (This field is present in your excel file) for each ITEM ID.
MAX(Modified Date) as MaxModifiedDate
FROM [your file]
GROUP BY [ITEM ID];