How can I model the following bottom table in script

[D19PAL]

Hi Guys,

How can I get the bottom table from the top resident table?

Thanks

Top table Resident

Name	Date 1	order date	Id	Before_or_ after
John	01/01/2010	01/01/2010	1	Before
John	01/01/2010	01/01/2010	1	Before
John	01/01/2010	01/01/2010	1	Before
John	01/01/2010	05/01/2010	2	After
John	01/01/2010	05/01/2010	2	After
John	01/01/2010	05/01/2010	2	After
Paul	01/01/2010	01/01/2010	3	Before
Paul	01/01/2010	01/01/2010	3	Before
Paul	01/01/2010	01/01/2010	3	Before
Paul	01/01/2010	05/01/2010	4	After
Paul	01/01/2010	05/01/2010	4	After
Paul	01/01/2010	05/01/2010	4	After
What I need from the resident table In the table below.
Name	Id	Before_or After
John	1	Before
John	2	After
Paul	3	Before
Paul	4	After

[Saravanan_Desingh]

Please check this.

https://community.qlik.com/t5/New-to-Qlik-Sense/How-can-I-get-the-second-table-from-the-resident-tab...