https://community.qlik.com/t5/QlikView/CONCATENATE-2-TABLES/m-p/1685538#M726375 <P>attached file with solution</P><P>&nbsp;</P> Wed, 18 Mar 2020 03:38:27 GMT Lech_Miszkiewicz 2020-03-18T03:38:27Z https://community.qlik.com/t5/QlikView/CONCATENATE-2-TABLES/m-p/1685534#M726373 <P>I have data as the attached sample file..I have also attached the sample QV file.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="TestSP.PNG" style="width: 271px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/30201iE67E615D13B556B6/image-size/large?v=v2&amp;px=999" role="button" title="TestSP.PNG" alt="TestSP.PNG" /></span></P><P>I need the Airlines to be allocated for 2020 Qtr 2 as well, how can I do that in the script leve ?</P><P>Thank you much.</P> Sat, 16 Nov 2024 18:55:42 GMT https://community.qlik.com/t5/QlikView/CONCATENATE-2-TABLES/m-p/1685534#M726373 apthansh 2024-11-16T18:55:42Z https://community.qlik.com/t5/QlikView/CONCATENATE-2-TABLES/m-p/1685537#M726374 <P>creating mapping table from sheet 1 and applying it would do the job.</P><P>more on that in Rob's post</P><P><A href="https://qlikviewcookbook.com/2020/03/creating-temporary-script-associations/" target="_blank">https://qlikviewcookbook.com/2020/03/creating-temporary-script-associations/</A></P> Wed, 18 Mar 2020 03:35:32 GMT https://community.qlik.com/t5/QlikView/CONCATENATE-2-TABLES/m-p/1685537#M726374 Lech_Miszkiewicz 2020-03-18T03:35:32Z https://community.qlik.com/t5/QlikView/CONCATENATE-2-TABLES/m-p/1685538#M726375 <P>attached file with solution</P><P>&nbsp;</P> Wed, 18 Mar 2020 03:38:27 GMT https://community.qlik.com/t5/QlikView/CONCATENATE-2-TABLES/m-p/1685538#M726375 Lech_Miszkiewicz 2020-03-18T03:38:27Z