topic Re: Remove duplicate in Script in QlikView

Remove duplicate in Script

Wed, 12 Feb 2014 11:10:44 GMT

I have a script that shows the following data say named : DataList

DataList

LocationID	DATE
7001	6/2/2013
7001	6/2/2013
7001	7/2/2013
7001	8/2/2013
2000	12/3/2013
3000	6/2/2013

I need another script that removed the duplicated dates for same locationID and add another column which show number of duplicate for each date so have to be like this

LocationID	Date	CountDate
7001	6/2/2013	2
7001	7/2/2013	1
7001	8/2/2013	1
2000	12/3/2013	1
3000	6/2/2013	1

Please anyone help this is important

Re: Remove duplicate in Script

rbecher — Wed, 12 Feb 2014 11:16:38 GMT

Hi,

you can aggregate into a new table:

Result:

NOCONCATENATE LOAD LocationID, Date, Count(Date) as CountDate

Resident DataList

Group By LocationID, Date;

- Ralf

Re: Remove duplicate in Script

Wed, 12 Feb 2014 11:23:03 GMT

Thanks alot man . Your a life saver

Re: Remove duplicate in Script

amit_saini — Wed, 12 Feb 2014 11:30:24 GMT

Hi,

Please try this:

Task:

NOCONCATENATE LOAD Location, Date, Count(Date) as CountDate

Resident Test

Group By Location, Date;

Where 'Test' is the name where you are calling your table.

Thanks,