How to display add/remove and count of id?

silambarasan — Thu, 26 May 2016 13:35:30 GMT

Day-1:

ID,Date

A, 1-jan-2016

B,1-jan-2016

C,1-jan-2016

D,1-jan-2016

Day-2

ID,Date

A, 2-jan-2016

B,2-jan-2016

C,2-jan-2016

E,2-jan-2016

I want three tables

Table one display count of id on daily basis.

Table two display newly added id on daily basis

Table three display removed id.

table-1

if i click 2-jan in table-1 ,it will show list of new id added and list of existing id removed in two separate table

Eg:

Day-2

table-2

ID	newtype
E	new

table-3

ID	newtype
D	remove

note:

need scripting preferable

Message was edited by: Silambarasan M

Re: How to display add/remove and count of id?

settu_periasamy — Fri, 27 May 2016 05:48:52 GMT

Hi,

May be check the Attachment..

silambarasan — Fri, 27 May 2016 06:03:36 GMT

1. No sethu.When i click day-2 it shows only newly added id and not show removed id.

2. synthetic key formed

3. please don't do this in inline table