Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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.
please help,
Thanks a lot,
Regards,
Bikash
Yes, I am using the group by, this way,
Load
ITEM_ID,
max(MODIFIED_DATE) as MaxDate
resident (mytable)
Group by ITEM_ID ;
This code wouldn´t duplicate data.
Where do you see your duplicate data?
A Graph? Which Dimentions are you using in it?
I am seeing that in a table box. 😞
I´m guessing you have MODIFIED_DATE in your table, right?
Remove it from your table just to check.
It would be easier if you upload a qvw
Hello Bikash,
Is it working now?
That´s great news.
Please mark the topic as 'answered', so
Best regards