topic change the structure in QlikView

topic change the structure in QlikView https://community.qlik.com/t5/QlikView/change-the-structure/m-p/1430251#M430300 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a file with data like,</P><P></P><P></P><P>input data:</P><P>  </P><TABLE border="1px" cellpadding="0" cellspacing="0" jive-data-cell="{"color":"#575757","textAlign":"-webkit-right","padding":"NaN","backgroundColor":"transparent","fontFamily":"arial,helvetica,sans-serif","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}" style="width: 576px; border-width: 1px; border-style: solid;"><TBODY><TR><TD class="xl65" height="20" width="64"> </TD><TD class="xl65" width="64"> </TD><TD class="xl65" width="64"> </TD><TD class="xl68" colspan="3" width="192">Manager</TD><TD class="xl68" colspan="3" width="192">Chief</TD></TR><TR><TD class="xl65" height="20">Name</TD><TD class="xl65">Start Date</TD><TD class="xl65">City</TD><TD align="right" class="xl66">Jan-17</TD><TD align="right" class="xl66">Feb-17</TD><TD align="right" class="xl66">Mar-17</TD><TD align="right" class="xl66">Jan-17</TD><TD align="right" class="xl66">Feb-17</TD><TD align="right" class="xl66">Mar-17</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Chennai</TD><TD align="right" class="xl65">5</TD><TD align="right" class="xl65">6</TD><TD align="right" class="xl65">7</TD><TD align="right" class="xl65">8</TD><TD align="right" class="xl65">9</TD><TD align="right" class="xl65">5</TD></TR><TR><TD class="xl65" height="20"> </TD><TD class="xl65"> </TD><TD class="xl65">Trichy</TD><TD align="right" class="xl65">4</TD><TD align="right" class="xl65">24</TD><TD align="right" class="xl65">3</TD><TD align="right" class="xl65">2</TD><TD align="right" class="xl65">4</TD><TD align="right" class="xl65">6</TD></TR><TR><TD class="xl65" height="20"> </TD><TD class="xl65"> </TD><TD class="xl65">Madurai</TD><TD align="right" class="xl65">5</TD><TD align="right" class="xl65">6</TD><TD align="right" class="xl65">7</TD><TD align="right" class="xl65">8</TD><TD align="right" class="xl65">8</TD><TD align="right" class="xl65">9</TD></TR></TBODY></TABLE><P></P><P>I need the above table as below format,</P><P></P><P>  </P><TABLE border="1px" cellpadding="0" cellspacing="0" jive-data-cell="{"color":"#575757","textAlign":"-webkit-right","padding":"NaN","backgroundColor":"transparent","fontFamily":"arial,helvetica,sans-serif","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}" style="width: 384px; border-width: 1px; border-style: solid;"><TBODY><TR><TD class="xl65" height="20" width="64">Name</TD><TD class="xl65" width="64">Start Date</TD><TD class="xl65" width="64">City</TD><TD class="xl65" width="64">Position</TD><TD class="xl65" width="64">MonthYr</TD><TD class="xl65" width="64">Value</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Chennai</TD><TD class="xl65">Manager</TD><TD align="right" class="xl66">Jan-17</TD><TD align="right" class="xl65">5</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Chennai</TD><TD class="xl65">Manager</TD><TD align="right" class="xl66">Feb-17</TD><TD align="right" class="xl65">6</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Chennai</TD><TD class="xl65">Manager</TD><TD align="right" class="xl66">Mar-17</TD><TD align="right" class="xl65">7</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Trichy</TD><TD class="xl65">Manager</TD><TD align="right" class="xl66">Jan-17</TD><TD align="right" class="xl65">4</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Trichy</TD><TD class="xl65">Manager</TD><TD align="right" class="xl66">Feb-17</TD><TD align="right" class="xl65">24</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Trichy</TD><TD class="xl65">Manager</TD><TD align="right" class="xl66">Mar-17</TD><TD align="right" class="xl65">3</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Madurai</TD><TD class="xl65">Manager</TD><TD align="right" class="xl66">Jan-17</TD><TD align="right" class="xl65">5</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Madurai</TD><TD class="xl65">Manager</TD><TD align="right" class="xl66">Feb-17</TD><TD align="right" class="xl65">6</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Madurai</TD><TD class="xl65">Manager</TD><TD align="right" class="xl66">Mar-17</TD><TD align="right" class="xl65">7</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Chennai</TD><TD class="xl65">Chief</TD><TD align="right" class="xl66">Jan-17</TD><TD align="right" class="xl65">8</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Chennai</TD><TD class="xl65">Chief</TD><TD align="right" class="xl66">Feb-17</TD><TD align="right" class="xl65">9</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Chennai</TD><TD class="xl65">Chief</TD><TD align="right" class="xl66">Mar-17</TD><TD align="right" class="xl65">5</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Trichy</TD><TD class="xl65">Chief</TD><TD align="right" class="xl66">Jan-17</TD><TD align="right" class="xl65">2</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Trichy</TD><TD class="xl65">Chief</TD><TD align="right" class="xl66">Feb-17</TD><TD align="right" class="xl65">4</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Trichy</TD><TD class="xl65">Chief</TD><TD align="right" class="xl66">Mar-17</TD><TD align="right" class="xl65">6</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Madurai</TD><TD class="xl65">Chief</TD><TD align="right" class="xl66">Jan-17</TD><TD align="right" class="xl65">8</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Madurai</TD><TD class="xl65">Chief</TD><TD align="right" class="xl66">Feb-17</TD><TD align="right" class="xl65">8</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Madurai</TD><TD class="xl65">Chief</TD><TD align="right" class="xl66">Mar-17</TD><TD align="right" class="xl65">9</TD></TR></TBODY></TABLE><P></P><P>How can i achieve this??</P><P>Help me.</P><P></P><P>Here i attached sample excel file.</P></BODY></HTML> Sat, 19 Aug 2017 19:16:10 GMT jeevays7 2017-08-19T19:16:10Z change the structure https://community.qlik.com/t5/QlikView/change-the-structure/m-p/1430251#M430300 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a file with data like,</P><P></P><P></P><P>input data:</P><P>  </P><TABLE border="1px" cellpadding="0" cellspacing="0" jive-data-cell="{"color":"#575757","textAlign":"-webkit-right","padding":"NaN","backgroundColor":"transparent","fontFamily":"arial,helvetica,sans-serif","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}" style="width: 576px; border-width: 1px; border-style: solid;"><TBODY><TR><TD class="xl65" height="20" width="64"> </TD><TD class="xl65" width="64"> </TD><TD class="xl65" width="64"> </TD><TD class="xl68" colspan="3" width="192">Manager</TD><TD class="xl68" colspan="3" width="192">Chief</TD></TR><TR><TD class="xl65" height="20">Name</TD><TD class="xl65">Start Date</TD><TD class="xl65">City</TD><TD align="right" class="xl66">Jan-17</TD><TD align="right" class="xl66">Feb-17</TD><TD align="right" class="xl66">Mar-17</TD><TD align="right" class="xl66">Jan-17</TD><TD align="right" class="xl66">Feb-17</TD><TD align="right" class="xl66">Mar-17</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Chennai</TD><TD align="right" class="xl65">5</TD><TD align="right" class="xl65">6</TD><TD align="right" class="xl65">7</TD><TD align="right" class="xl65">8</TD><TD align="right" class="xl65">9</TD><TD align="right" class="xl65">5</TD></TR><TR><TD class="xl65" height="20"> </TD><TD class="xl65"> </TD><TD class="xl65">Trichy</TD><TD align="right" class="xl65">4</TD><TD align="right" class="xl65">24</TD><TD align="right" class="xl65">3</TD><TD align="right" class="xl65">2</TD><TD align="right" class="xl65">4</TD><TD align="right" class="xl65">6</TD></TR><TR><TD class="xl65" height="20"> </TD><TD class="xl65"> </TD><TD class="xl65">Madurai</TD><TD align="right" class="xl65">5</TD><TD align="right" class="xl65">6</TD><TD align="right" class="xl65">7</TD><TD align="right" class="xl65">8</TD><TD align="right" class="xl65">8</TD><TD align="right" class="xl65">9</TD></TR></TBODY></TABLE><P></P><P>I need the above table as below format,</P><P></P><P>  </P><TABLE border="1px" cellpadding="0" cellspacing="0" jive-data-cell="{"color":"#575757","textAlign":"-webkit-right","padding":"NaN","backgroundColor":"transparent","fontFamily":"arial,helvetica,sans-serif","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}" style="width: 384px; border-width: 1px; border-style: solid;"><TBODY><TR><TD class="xl65" height="20" width="64">Name</TD><TD class="xl65" width="64">Start Date</TD><TD class="xl65" width="64">City</TD><TD class="xl65" width="64">Position</TD><TD class="xl65" width="64">MonthYr</TD><TD class="xl65" width="64">Value</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Chennai</TD><TD class="xl65">Manager</TD><TD align="right" class="xl66">Jan-17</TD><TD align="right" class="xl65">5</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Chennai</TD><TD class="xl65">Manager</TD><TD align="right" class="xl66">Feb-17</TD><TD align="right" class="xl65">6</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Chennai</TD><TD class="xl65">Manager</TD><TD align="right" class="xl66">Mar-17</TD><TD align="right" class="xl65">7</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Trichy</TD><TD class="xl65">Manager</TD><TD align="right" class="xl66">Jan-17</TD><TD align="right" class="xl65">4</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Trichy</TD><TD class="xl65">Manager</TD><TD align="right" class="xl66">Feb-17</TD><TD align="right" class="xl65">24</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Trichy</TD><TD class="xl65">Manager</TD><TD align="right" class="xl66">Mar-17</TD><TD align="right" class="xl65">3</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Madurai</TD><TD class="xl65">Manager</TD><TD align="right" class="xl66">Jan-17</TD><TD align="right" class="xl65">5</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Madurai</TD><TD class="xl65">Manager</TD><TD align="right" class="xl66">Feb-17</TD><TD align="right" class="xl65">6</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Madurai</TD><TD class="xl65">Manager</TD><TD align="right" class="xl66">Mar-17</TD><TD align="right" class="xl65">7</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Chennai</TD><TD class="xl65">Chief</TD><TD align="right" class="xl66">Jan-17</TD><TD align="right" class="xl65">8</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Chennai</TD><TD class="xl65">Chief</TD><TD align="right" class="xl66">Feb-17</TD><TD align="right" class="xl65">9</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Chennai</TD><TD class="xl65">Chief</TD><TD align="right" class="xl66">Mar-17</TD><TD align="right" class="xl65">5</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Trichy</TD><TD class="xl65">Chief</TD><TD align="right" class="xl66">Jan-17</TD><TD align="right" class="xl65">2</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Trichy</TD><TD class="xl65">Chief</TD><TD align="right" class="xl66">Feb-17</TD><TD align="right" class="xl65">4</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Trichy</TD><TD class="xl65">Chief</TD><TD align="right" class="xl66">Mar-17</TD><TD align="right" class="xl65">6</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Madurai</TD><TD class="xl65">Chief</TD><TD align="right" class="xl66">Jan-17</TD><TD align="right" class="xl65">8</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Madurai</TD><TD class="xl65">Chief</TD><TD align="right" class="xl66">Feb-17</TD><TD align="right" class="xl65">8</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right" class="xl67">1/1/2017</TD><TD class="xl65">Madurai</TD><TD class="xl65">Chief</TD><TD align="right" class="xl66">Mar-17</TD><TD align="right" class="xl65">9</TD></TR></TBODY></TABLE><P></P><P>How can i achieve this??</P><P>Help me.</P><P></P><P>Here i attached sample excel file.</P></BODY></HTML> Sat, 19 Aug 2017 19:16:10 GMT https://community.qlik.com/t5/QlikView/change-the-structure/m-p/1430251#M430300 jeevays7 2017-08-19T19:16:10Z Re: change the structure https://community.qlik.com/t5/QlikView/change-the-structure/m-p/1430252#M430301 <HTML><HEAD></HEAD><BODY><P>Try to load data in different table </P><P></P><P>1. First for the Manager with cross table.</P><P>2. Second with the <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Chief and concatenate this tables.</SPAN></P></BODY></HTML> Sat, 19 Aug 2017 19:57:45 GMT https://community.qlik.com/t5/QlikView/change-the-structure/m-p/1430252#M430301 its_anandrjs 2017-08-19T19:57:45Z Re: change the structure https://community.qlik.com/t5/QlikView/change-the-structure/m-p/1430253#M430302 <HTML><HEAD></HEAD><BODY><P>The only option is this.I don't think we can work around with second ways</P></BODY></HTML> Sun, 20 Aug 2017 00:56:35 GMT https://community.qlik.com/t5/QlikView/change-the-structure/m-p/1430253#M430302 Anil_Babu_Samineni 2017-08-20T00:56:35Z