topic Load multiple table from excel in QlikView https://community.qlik.com/t5/QlikView/Load-multiple-table-from-excel/m-p/1325976#M833880 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; you can find the example in the attachment.</P><P></P><P>Strarting from the example I would like to arrive to this situation:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">shop_id</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>hour</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>month</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">year</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>value</STRONG></TH></TR><TR><TD style="padding: 2px;">xyz</TD><TD style="padding: 2px;">00:00:00</TD><TD style="padding: 2px;">jan</TD><TD style="padding: 2px;">2015</TD><TD style="padding: 2px;">1.12</TD></TR><TR><TD style="padding: 2px;">xyz</TD><TD style="padding: 2px;">00:15:00</TD><TD style="padding: 2px;">jan</TD><TD style="padding: 2px;">2015</TD><TD style="padding: 2px;">1.15</TD></TR></TBODY></TABLE><P></P><P>or to a situatin that I can hadle in with qlikview.</P><P></P><P>I tried to use cross table option, but it's not enough.</P><P>Please help me, thanks.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Load multiple table from excel https://community.qlik.com/t5/QlikView/Load-multiple-table-from-excel/m-p/1325976#M833880 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; you can find the example in the attachment.</P><P></P><P>Strarting from the example I would like to arrive to this situation:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">shop_id</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>hour</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>month</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">year</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>value</STRONG></TH></TR><TR><TD style="padding: 2px;">xyz</TD><TD style="padding: 2px;">00:00:00</TD><TD style="padding: 2px;">jan</TD><TD style="padding: 2px;">2015</TD><TD style="padding: 2px;">1.12</TD></TR><TR><TD style="padding: 2px;">xyz</TD><TD style="padding: 2px;">00:15:00</TD><TD style="padding: 2px;">jan</TD><TD style="padding: 2px;">2015</TD><TD style="padding: 2px;">1.15</TD></TR></TBODY></TABLE><P></P><P>or to a situatin that I can hadle in with qlikview.</P><P></P><P>I tried to use cross table option, but it's not enough.</P><P>Please help me, thanks.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Load-multiple-table-from-excel/m-p/1325976#M833880 Anonymous 2020-11-25T16:16:04Z Re: Load multiple table from excel https://community.qlik.com/t5/QlikView/Load-multiple-table-from-excel/m-p/1325977#M833881 <HTML><HEAD></HEAD><BODY><P>see attach</P></BODY></HTML> Wed, 07 Jun 2017 12:52:15 GMT https://community.qlik.com/t5/QlikView/Load-multiple-table-from-excel/m-p/1325977#M833881 florentina_doga 2017-06-07T12:52:15Z