topic Re: How to Combine 2 table into 1 in QlikView https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013640#M642442 <HTML><HEAD></HEAD><BODY><P>Hi Andy</P><P></P><P>But the 2 table in side have a lot expression , can you share with me by give me some link to see how to achieve this ?</P><P></P><P>Paul</P><P></P><P>Sent from my iPhone</P></BODY></HTML> Fri, 01 Jan 2016 22:08:53 GMT paulyeo11 2016-01-01T22:08:53Z How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013632#M642434 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P></P><P>I have 2 Table , i like to make this 2 table combine as 1 table and i want to achieve the same report like i manually arrange.</P><P></P><P>My next post i will file attach my QV Doc</P><P></P><P></P><P>Paul</P></BODY></HTML> Fri, 01 Jan 2016 14:27:44 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013632#M642434 paulyeo11 2016-01-01T14:27:44Z Re: How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013633#M642435 <HTML><HEAD></HEAD><BODY><P>What do you mean by combine?</P><P>You can add both table to container to have them in one place.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: 'comic sans ms', sans-serif;">Feeling Qlikngry?</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="8342" data-objecttype="102" href="https://community.qlik.com/docs/DOC-8342" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">How To /Missing Manual(24 articles)</A></P></BODY></HTML> Fri, 01 Jan 2016 16:03:16 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013633#M642435 robert_mika 2016-01-01T16:03:16Z Re: How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013634#M642436 <HTML><HEAD></HEAD><BODY><P>‌to combine 2 tables into 1 why don't you concatenation them together into one table on load?</P></BODY></HTML> Fri, 01 Jan 2016 17:27:49 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013634#M642436 ogster1974 2016-01-01T17:27:49Z Re: How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013635#M642437 <HTML><HEAD></HEAD><BODY><P>Something like this?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/110406_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Fri, 01 Jan 2016 19:55:01 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013635#M642437 sunny_talwar 2016-01-01T19:55:01Z Re: How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013636#M642438 <HTML><HEAD></HEAD><BODY><P>Hi sunny</P><P></P><P>Can you tell me how you do it ? It look okay </P><P></P><P>Paul</P><P></P><P>Sent from my iPhone</P></BODY></HTML> Fri, 01 Jan 2016 21:44:53 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013636#M642438 paulyeo11 2016-01-01T21:44:53Z Re: How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013637#M642439 <HTML><HEAD></HEAD><BODY><P>You should see the data model...</P></BODY></HTML> Fri, 01 Jan 2016 21:54:18 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013637#M642439 robert_mika 2016-01-01T21:54:18Z Re: How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013638#M642440 <HTML><HEAD></HEAD><BODY><P>Hi Robert</P><P></P><P>I saw you spend a lot of time to organise the missing manual , I am interested to know how you do it ? Can share with me ? </P><P></P><P>Paul</P><P></P><P>Sent from my iPhone</P></BODY></HTML> Fri, 01 Jan 2016 22:01:05 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013638#M642440 paulyeo11 2016-01-01T22:01:05Z Re: How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013639#M642441 <HTML><HEAD></HEAD><BODY><P>Hi Robert</P><P></P><P>Any suggestion you like to share with me ? To clear the sync key will it make the data model look better ? Or create the link table ? </P><P></P><P>As I also hope one day my data model can be improve.</P><P></P><P>Paul</P><P></P><P>Sent from my iPhone</P></BODY></HTML> Fri, 01 Jan 2016 22:07:41 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013639#M642441 paulyeo11 2016-01-01T22:07:41Z Re: How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013640#M642442 <HTML><HEAD></HEAD><BODY><P>Hi Andy</P><P></P><P>But the 2 table in side have a lot expression , can you share with me by give me some link to see how to achieve this ?</P><P></P><P>Paul</P><P></P><P>Sent from my iPhone</P></BODY></HTML> Fri, 01 Jan 2016 22:08:53 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013640#M642442 paulyeo11 2016-01-01T22:08:53Z Re: How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013641#M642443 <HTML><HEAD></HEAD><BODY><P>It is a container object with these presentation settings:</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/110407_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Fri, 01 Jan 2016 22:15:57 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013641#M642443 sunny_talwar 2016-01-01T22:15:57Z Re: How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013642#M642444 <HTML><HEAD></HEAD><BODY><P>I am using v9 , does ver 9 support container object ?</P><P></P><P>Paul</P><P></P><P>Sent from my iPhone</P></BODY></HTML> Fri, 01 Jan 2016 23:09:30 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013642#M642444 paulyeo11 2016-01-01T23:09:30Z Re: How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013643#M642445 <HTML><HEAD></HEAD><BODY><P>Hi Paul,</P><P>Are the any reasons why are still on v9?</P></BODY></HTML> Fri, 01 Jan 2016 23:17:58 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013643#M642445 robert_mika 2016-01-01T23:17:58Z Re: How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013644#M642446 <HTML><HEAD></HEAD><BODY><P>Hi Robert </P><P></P><P>I don't have any Budget to upgrade.</P><P></P><P>Paul</P><P></P><P>Sent from my iPhone</P></BODY></HTML> Fri, 01 Jan 2016 23:22:42 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013644#M642446 paulyeo11 2016-01-01T23:22:42Z Re: How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013645#M642447 <HTML><HEAD></HEAD><BODY><P>Understood.</P><P>Most of the folks here are using v11 so asking question on v9 can be left unanswered.</P><P>To be honest I did not know that you have to pay for upgrade.</P></BODY></HTML> Fri, 01 Jan 2016 23:27:18 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013645#M642447 robert_mika 2016-01-01T23:27:18Z Re: How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013646#M642448 <HTML><HEAD></HEAD><BODY><P>Hi Robert</P><P></P><P>Since I am using QS to binary load my QV Data. Does QS support container ? Any idea ? If it does support , I can develop the report in QS .</P><P></P><P>Sent from my iPhone</P></BODY></HTML> Sat, 02 Jan 2016 00:25:42 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013646#M642448 paulyeo11 2016-01-02T00:25:42Z Re: How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013647#M642449 <HTML><HEAD></HEAD><BODY><P>So far there is no container for QS</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: 'comic sans ms', sans-serif;">Feeling Qlikngry?</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="8342" data-objecttype="102" href="https://community.qlik.com/docs/DOC-8342" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">How To /Missing Manual(24 articles)</A></P></BODY></HTML> Sat, 02 Jan 2016 00:34:15 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013647#M642449 robert_mika 2016-01-02T00:34:15Z Re: How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013648#M642450 <HTML><HEAD></HEAD><BODY><P>You don't pay for an "upgrade", you pay a fee for maintenance. When you stop paying your maintenance fee, your license will be restricted to the last version in the paid maintenance period.</P></BODY></HTML> Sat, 02 Jan 2016 12:02:13 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013648#M642450 Peter_Cammaert 2016-01-02T12:02:13Z Re: How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013649#M642453 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM>I am using v9 , does ver 9 support container object ?</EM></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">No. Container objects were a new feature in QV10, and got an upgrade in QV11.<BR /></SPAN></P></BODY></HTML> Sat, 02 Jan 2016 12:12:04 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013649#M642453 Peter_Cammaert 2016-01-02T12:12:04Z Re: How to Combine 2 table into 1 https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013650#M642455 <HTML><HEAD></HEAD><BODY><P>Hi Peter</P><P></P><P>Thank you for your info.</P><P></P><P>It is okay I will think of work around. </P><P></P><P>Paul</P><P></P><P>Sent from my iPhone</P></BODY></HTML> Sat, 02 Jan 2016 13:04:07 GMT https://community.qlik.com/t5/QlikView/How-to-Combine-2-table-into-1/m-p/1013650#M642455 paulyeo11 2016-01-02T13:04:07Z