topic How can I model the following bottom table in script in QlikView https://community.qlik.com/t5/QlikView/How-can-I-model-the-following-bottom-table-in-script/m-p/1790053#M1210512 <P>Hi Guys,</P><P>&nbsp;</P><P>How can I get the bottom table from the top resident table?</P><P>Thanks</P><P>&nbsp;</P><P>Top table Resident</P><TABLE><TBODY><TR><TD>Name</TD><TD>Date 1</TD><TD>order date</TD><TD>Id</TD><TD>Before_or_ after</TD></TR><TR><TD>John</TD><TD>01/01/2010</TD><TD>01/01/2010</TD><TD>1</TD><TD>Before</TD></TR><TR><TD>John</TD><TD>01/01/2010</TD><TD>01/01/2010</TD><TD>1</TD><TD>Before</TD></TR><TR><TD>John</TD><TD>01/01/2010</TD><TD>01/01/2010</TD><TD>1</TD><TD>Before</TD></TR><TR><TD>John</TD><TD>01/01/2010</TD><TD>05/01/2010</TD><TD>2</TD><TD>After</TD></TR><TR><TD>John</TD><TD>01/01/2010</TD><TD>05/01/2010</TD><TD>2</TD><TD>After</TD></TR><TR><TD>John</TD><TD>01/01/2010</TD><TD>05/01/2010</TD><TD>2</TD><TD>After</TD></TR><TR><TD>Paul</TD><TD>01/01/2010</TD><TD>01/01/2010</TD><TD>3</TD><TD>Before</TD></TR><TR><TD>Paul</TD><TD>01/01/2010</TD><TD>01/01/2010</TD><TD>3</TD><TD>Before</TD></TR><TR><TD>Paul</TD><TD>01/01/2010</TD><TD>01/01/2010</TD><TD>3</TD><TD>Before</TD></TR><TR><TD>Paul</TD><TD>01/01/2010</TD><TD>05/01/2010</TD><TD>4</TD><TD>After</TD></TR><TR><TD>Paul</TD><TD>01/01/2010</TD><TD>05/01/2010</TD><TD>4</TD><TD>After</TD></TR><TR><TD>Paul</TD><TD>01/01/2010</TD><TD>05/01/2010</TD><TD>4</TD><TD>After</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>What I need from the resident table In the table below.&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Name</TD><TD>Id</TD><TD>Before_or After</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>John</TD><TD>1</TD><TD>Before</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>John</TD><TD>2</TD><TD>After</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Paul</TD><TD>3</TD><TD>Before</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Paul</TD><TD>4</TD><TD>After</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Wed, 10 Mar 2021 13:43:36 GMT D19PAL 2021-03-10T13:43:36Z How can I model the following bottom table in script https://community.qlik.com/t5/QlikView/How-can-I-model-the-following-bottom-table-in-script/m-p/1790053#M1210512 <P>Hi Guys,</P><P>&nbsp;</P><P>How can I get the bottom table from the top resident table?</P><P>Thanks</P><P>&nbsp;</P><P>Top table Resident</P><TABLE><TBODY><TR><TD>Name</TD><TD>Date 1</TD><TD>order date</TD><TD>Id</TD><TD>Before_or_ after</TD></TR><TR><TD>John</TD><TD>01/01/2010</TD><TD>01/01/2010</TD><TD>1</TD><TD>Before</TD></TR><TR><TD>John</TD><TD>01/01/2010</TD><TD>01/01/2010</TD><TD>1</TD><TD>Before</TD></TR><TR><TD>John</TD><TD>01/01/2010</TD><TD>01/01/2010</TD><TD>1</TD><TD>Before</TD></TR><TR><TD>John</TD><TD>01/01/2010</TD><TD>05/01/2010</TD><TD>2</TD><TD>After</TD></TR><TR><TD>John</TD><TD>01/01/2010</TD><TD>05/01/2010</TD><TD>2</TD><TD>After</TD></TR><TR><TD>John</TD><TD>01/01/2010</TD><TD>05/01/2010</TD><TD>2</TD><TD>After</TD></TR><TR><TD>Paul</TD><TD>01/01/2010</TD><TD>01/01/2010</TD><TD>3</TD><TD>Before</TD></TR><TR><TD>Paul</TD><TD>01/01/2010</TD><TD>01/01/2010</TD><TD>3</TD><TD>Before</TD></TR><TR><TD>Paul</TD><TD>01/01/2010</TD><TD>01/01/2010</TD><TD>3</TD><TD>Before</TD></TR><TR><TD>Paul</TD><TD>01/01/2010</TD><TD>05/01/2010</TD><TD>4</TD><TD>After</TD></TR><TR><TD>Paul</TD><TD>01/01/2010</TD><TD>05/01/2010</TD><TD>4</TD><TD>After</TD></TR><TR><TD>Paul</TD><TD>01/01/2010</TD><TD>05/01/2010</TD><TD>4</TD><TD>After</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>What I need from the resident table In the table below.&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Name</TD><TD>Id</TD><TD>Before_or After</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>John</TD><TD>1</TD><TD>Before</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>John</TD><TD>2</TD><TD>After</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Paul</TD><TD>3</TD><TD>Before</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Paul</TD><TD>4</TD><TD>After</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Wed, 10 Mar 2021 13:43:36 GMT https://community.qlik.com/t5/QlikView/How-can-I-model-the-following-bottom-table-in-script/m-p/1790053#M1210512 D19PAL 2021-03-10T13:43:36Z Re: How can I model the following bottom table in script https://community.qlik.com/t5/QlikView/How-can-I-model-the-following-bottom-table-in-script/m-p/1790062#M1210513 <P>Please check this.</P><P><A href="https://community.qlik.com/t5/New-to-Qlik-Sense/How-can-I-get-the-second-table-from-the-resident-table/td-p/1790054" target="_blank">https://community.qlik.com/t5/New-to-Qlik-Sense/How-can-I-get-the-second-table-from-the-resident-table/td-p/1790054</A></P> Wed, 10 Mar 2021 13:57:26 GMT https://community.qlik.com/t5/QlikView/How-can-I-model-the-following-bottom-table-in-script/m-p/1790062#M1210513 Saravanan_Desingh 2021-03-10T13:57:26Z