topic Re: Append to the previous Data Structure in QlikView https://community.qlik.com/t5/QlikView/Append-to-the-previous-Data-Structure/m-p/98415#M15729 <HTML><HEAD></HEAD><BODY><P>I want to append the new table into any particular table.</P></BODY></HTML> Thu, 01 Nov 2018 06:18:29 GMT ahmar811 2018-11-01T06:18:29Z Append to the previous Data Structure https://community.qlik.com/t5/QlikView/Append-to-the-previous-Data-Structure/m-p/98412#M15726 <HTML><HEAD></HEAD><BODY><P>Hi Expert,</P><P></P><P>I have below data model and I want to add some client data just like append to the previous structure </P><P><IMG alt="export.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/217266_export.png" style="height: auto;" /></P><P></P><P>we have to add below the table on above structure.</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH><SPAN style="color: #363636;"><STRONG>A</STRONG></SPAN><STRONG> </STRONG></TH><TH><SPAN style="color: #363636;"><STRONG>C</STRONG></SPAN><STRONG> </STRONG></TH><TH><SPAN style="color: #363636;"><STRONG>D</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Value</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">789</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">101112</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">HIJ</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">457</SPAN></TD></TR></TBODY></TABLE><P></P><P>Note: Here we don't have Field <STRONG>'B' </STRONG>and also data comes base on selections</P><P></P><P></P><P>Regards</P><P>Ahmar</P></BODY></HTML> Thu, 01 Nov 2018 05:42:34 GMT https://community.qlik.com/t5/QlikView/Append-to-the-previous-Data-Structure/m-p/98412#M15726 ahmar811 2018-11-01T05:42:34Z Re: Append to the previous Data Structure https://community.qlik.com/t5/QlikView/Append-to-the-previous-Data-Structure/m-p/98413#M15727 <HTML><HEAD></HEAD><BODY><P>You can use the CONCATENATE prefix for the LOAD statement to append data to a table that has been previously loaded in your load script. It will also accept new fields and add them.</P></BODY></HTML> Thu, 01 Nov 2018 06:01:38 GMT https://community.qlik.com/t5/QlikView/Append-to-the-previous-Data-Structure/m-p/98413#M15727 petter 2018-11-01T06:01:38Z Re: Append to the previous Data Structure https://community.qlik.com/t5/QlikView/Append-to-the-previous-Data-Structure/m-p/98414#M15728 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Do you want to append the new data into any particular table or just want to add as a separate one.</P></BODY></HTML> Thu, 01 Nov 2018 06:06:09 GMT https://community.qlik.com/t5/QlikView/Append-to-the-previous-Data-Structure/m-p/98414#M15728 jobsonkjoseph 2018-11-01T06:06:09Z Re: Append to the previous Data Structure https://community.qlik.com/t5/QlikView/Append-to-the-previous-Data-Structure/m-p/98415#M15729 <HTML><HEAD></HEAD><BODY><P>I want to append the new table into any particular table.</P></BODY></HTML> Thu, 01 Nov 2018 06:18:29 GMT https://community.qlik.com/t5/QlikView/Append-to-the-previous-Data-Structure/m-p/98415#M15729 ahmar811 2018-11-01T06:18:29Z Re: Append to the previous Data Structure https://community.qlik.com/t5/QlikView/Append-to-the-previous-Data-Structure/m-p/98416#M15730 <HTML><HEAD></HEAD><BODY><P>If to append to a particular table, then as mentioned by Petter, CONCATENATE has to be used between the tables.</P></BODY></HTML> Thu, 01 Nov 2018 06:24:27 GMT https://community.qlik.com/t5/QlikView/Append-to-the-previous-Data-Structure/m-p/98416#M15730 jobsonkjoseph 2018-11-01T06:24:27Z