topic insert values in a excel table in QlikView https://community.qlik.com/t5/QlikView/insert-values-in-a-excel-table/m-p/645192#M672820 <HTML><HEAD></HEAD><BODY><P>Hello together,</P><P></P><P>new day new Problem.</P><P></P><P>I want to load the first table with</P><P></P><P>LOAD</P><P>Product;</P><P>€</P><P></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"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>€</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><P>5</P></TD></TR></TBODY></TABLE><P></P><P></P><P>how can i insert a new rows</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"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>€</STRONG></TH></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">7</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">8</TD></TR></TBODY></TABLE><P></P><P>to the original table. It should Display the following table.</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"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>€</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">7</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">8</TD></TR></TBODY></TABLE><P></P><P>What LOAD Statement I Need for this requirement</P><P></P><P>Thanks</P><P></P><P>Jörn</P></BODY></HTML> Mon, 25 Aug 2014 15:07:27 GMT 2014-08-25T15:07:27Z insert values in a excel table https://community.qlik.com/t5/QlikView/insert-values-in-a-excel-table/m-p/645192#M672820 <HTML><HEAD></HEAD><BODY><P>Hello together,</P><P></P><P>new day new Problem.</P><P></P><P>I want to load the first table with</P><P></P><P>LOAD</P><P>Product;</P><P>€</P><P></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"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>€</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><P>5</P></TD></TR></TBODY></TABLE><P></P><P></P><P>how can i insert a new rows</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"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>€</STRONG></TH></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">7</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">8</TD></TR></TBODY></TABLE><P></P><P>to the original table. It should Display the following table.</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"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>€</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">7</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">8</TD></TR></TBODY></TABLE><P></P><P>What LOAD Statement I Need for this requirement</P><P></P><P>Thanks</P><P></P><P>Jörn</P></BODY></HTML> Mon, 25 Aug 2014 15:07:27 GMT https://community.qlik.com/t5/QlikView/insert-values-in-a-excel-table/m-p/645192#M672820 2014-08-25T15:07:27Z Re: insert values in a excel table https://community.qlik.com/t5/QlikView/insert-values-in-a-excel-table/m-p/645193#M672821 <HTML><HEAD></HEAD><BODY><P>where do those new rows come from? Or should always the same row be added?</P></BODY></HTML> Mon, 25 Aug 2014 15:11:13 GMT https://community.qlik.com/t5/QlikView/insert-values-in-a-excel-table/m-p/645193#M672821 giakoum 2014-08-25T15:11:13Z Re: insert values in a excel table https://community.qlik.com/t5/QlikView/insert-values-in-a-excel-table/m-p/645194#M672822 <HTML><HEAD></HEAD><BODY><P>Maybe the Concatenate keyword would be of use?</P><P></P><P>Concatenate(Table1)</P><P>Load</P><P>....</P><P></P><P></P><P>Hope this helps!</P></BODY></HTML> Mon, 25 Aug 2014 15:14:26 GMT https://community.qlik.com/t5/QlikView/insert-values-in-a-excel-table/m-p/645194#M672822 jerem1234 2014-08-25T15:14:26Z Re: insert values in a excel table https://community.qlik.com/t5/QlikView/insert-values-in-a-excel-table/m-p/645195#M672823 <HTML><HEAD></HEAD><BODY><P>the new rows come from a formula which calculated the rows with sum function.</P><P>The Product C is a Sum formula and the Product D also.</P></BODY></HTML> Mon, 25 Aug 2014 15:16:34 GMT https://community.qlik.com/t5/QlikView/insert-values-in-a-excel-table/m-p/645195#M672823 2014-08-25T15:16:34Z Re: insert values in a excel table https://community.qlik.com/t5/QlikView/insert-values-in-a-excel-table/m-p/645196#M672824 <HTML><HEAD></HEAD><BODY><P>then the solution suggested by jeremiah is what you need.</P><P>concatenate(Table1)</P><P>load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Category</P><P>&nbsp;&nbsp;&nbsp;&nbsp; sum(€) as €</P><P>resident Table 1</P><P>group by </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Category</P><P></P><P>or similar...</P></BODY></HTML> Mon, 25 Aug 2014 15:20:54 GMT https://community.qlik.com/t5/QlikView/insert-values-in-a-excel-table/m-p/645196#M672824 giakoum 2014-08-25T15:20:54Z