topic Concatenate three tables in QlikView https://community.qlik.com/t5/QlikView/Concatenate-three-tables/m-p/80876#M771891 <HTML><HEAD></HEAD><BODY><P>I have three tables with all same fields - except the for the field sign data , Which contains different amounts but same field name . how do I concatenate all these three tables into one table and have amount fields show up as three different fields.</P><P></P><P></P><P>Example:</P><P></P><P>Actuals:</P><P>Load</P><P>Account_Exp,</P><P>Profit center,</P><P>costcenter,</P><P><SPAN style="color: #ff00ff;">signdata</SPAN></P><P>from</P><P> abc;</P><P></P><P>Budget:</P><P>Load</P><P>Account_Exp,</P><P>Profit center,</P><P>costcenter,</P><P><SPAN style="color: #ff00ff;">signdata</SPAN></P><P>from</P><P> abc;</P><P></P><P>forecast:</P><P>Load</P><P>Account_Exp,</P><P>Profit center,</P><P>costcenter,</P><P><SPAN style="color: #ff00ff;">signdata</SPAN></P><P>from</P><P> abc;</P><P></P><P></P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT krithikarees 2020-11-25T16:16:04Z Concatenate three tables https://community.qlik.com/t5/QlikView/Concatenate-three-tables/m-p/80876#M771891 <HTML><HEAD></HEAD><BODY><P>I have three tables with all same fields - except the for the field sign data , Which contains different amounts but same field name . how do I concatenate all these three tables into one table and have amount fields show up as three different fields.</P><P></P><P></P><P>Example:</P><P></P><P>Actuals:</P><P>Load</P><P>Account_Exp,</P><P>Profit center,</P><P>costcenter,</P><P><SPAN style="color: #ff00ff;">signdata</SPAN></P><P>from</P><P> abc;</P><P></P><P>Budget:</P><P>Load</P><P>Account_Exp,</P><P>Profit center,</P><P>costcenter,</P><P><SPAN style="color: #ff00ff;">signdata</SPAN></P><P>from</P><P> abc;</P><P></P><P>forecast:</P><P>Load</P><P>Account_Exp,</P><P>Profit center,</P><P>costcenter,</P><P><SPAN style="color: #ff00ff;">signdata</SPAN></P><P>from</P><P> abc;</P><P></P><P></P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Concatenate-three-tables/m-p/80876#M771891 krithikarees 2020-11-25T16:16:04Z Re: Concatenate three tables https://community.qlik.com/t5/QlikView/Concatenate-three-tables/m-p/80877#M771892 <HTML><HEAD></HEAD><BODY><P>Just renaming them like:</P><P></P><P>...</P><P><SPAN style="color: #ff00ff;">signdata as <SPAN style="color: #ff00ff;">signdataActuals,</SPAN><BR /></SPAN></P><P>...</P><P><SPAN style="color: #ff00ff;">signdata as <SPAN style="color: #ff00ff;">signdataBudget,</SPAN></SPAN></P><P>...</P><P><SPAN style="color: #ff00ff;">signdata as <SPAN style="color: #ff00ff;">signdataForecast,</SPAN></SPAN></P><P>...</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 23 May 2018 13:53:00 GMT https://community.qlik.com/t5/QlikView/Concatenate-three-tables/m-p/80877#M771892 marcus_sommer 2018-05-23T13:53:00Z