https://community.qlik.com/t5/QlikView/Merge-two-numeric-variables-from-2-different-tables/m-p/1820602#M1213447 <P>Hello,<BR />I got two numeric variables - Var1 and Var 2 in 2 different tables - A and B. They represent the same data so its safe to merge them</P><P>What I got now is:</P><P>Table A - Var1</P><P>100</P><P>200</P><P>300</P><P>Table B - Var2</P><P>100</P><P>200</P><P>300</P><P>What I would like to achieve</P><P>Var3</P><P>100</P><P>100</P><P>200</P><P>200</P><P>300</P><P>300</P><P>Could you help me resolving this problem? I've tried concatenate load but it doesn't quite work like I would like it to</P><P>Thank you in advance and have a good day! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 08 Jul 2021 07:03:55 GMT QlickySense 2021-07-08T07:03:55Z https://community.qlik.com/t5/QlikView/Merge-two-numeric-variables-from-2-different-tables/m-p/1820602#M1213447 <P>Hello,<BR />I got two numeric variables - Var1 and Var 2 in 2 different tables - A and B. They represent the same data so its safe to merge them</P><P>What I got now is:</P><P>Table A - Var1</P><P>100</P><P>200</P><P>300</P><P>Table B - Var2</P><P>100</P><P>200</P><P>300</P><P>What I would like to achieve</P><P>Var3</P><P>100</P><P>100</P><P>200</P><P>200</P><P>300</P><P>300</P><P>Could you help me resolving this problem? I've tried concatenate load but it doesn't quite work like I would like it to</P><P>Thank you in advance and have a good day! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 08 Jul 2021 07:03:55 GMT https://community.qlik.com/t5/QlikView/Merge-two-numeric-variables-from-2-different-tables/m-p/1820602#M1213447 QlickySense 2021-07-08T07:03:55Z