https://community.qlik.com/t5/Connectivity-Data-Prep/Join-to-concatenated-tables/m-p/1550847#M3653 <P>Hi guys,</P><P>I tried 'concatenate' and join&nbsp; as following.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rapture_20190301105130.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/7033i18957DE457F7B9C9/image-size/large?v=v2&amp;px=999" role="button" title="rapture_20190301105130.jpg" alt="rapture_20190301105130.jpg" /></span></P><P>&nbsp;</P><P>In the debug, script worked well, but Table C and D didn't join well.</P><P>It shows there is no data.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rapture_20190301110005.jpg" style="width: 210px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/7035i7504F3C1C3159CA6/image-size/large?v=v2&amp;px=999" role="button" title="rapture_20190301110005.jpg" alt="rapture_20190301110005.jpg" /></span></P><P>Please let's me know how I can join table to concatenated tables.</P><P>Thank&nbsp;you&nbsp;</P> Fri, 01 Mar 2019 02:03:15 GMT wenyan1206 2019-03-01T02:03:15Z https://community.qlik.com/t5/Connectivity-Data-Prep/Join-to-concatenated-tables/m-p/1550847#M3653 <P>Hi guys,</P><P>I tried 'concatenate' and join&nbsp; as following.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rapture_20190301105130.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/7033i18957DE457F7B9C9/image-size/large?v=v2&amp;px=999" role="button" title="rapture_20190301105130.jpg" alt="rapture_20190301105130.jpg" /></span></P><P>&nbsp;</P><P>In the debug, script worked well, but Table C and D didn't join well.</P><P>It shows there is no data.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rapture_20190301110005.jpg" style="width: 210px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/7035i7504F3C1C3159CA6/image-size/large?v=v2&amp;px=999" role="button" title="rapture_20190301110005.jpg" alt="rapture_20190301110005.jpg" /></span></P><P>Please let's me know how I can join table to concatenated tables.</P><P>Thank&nbsp;you&nbsp;</P> Fri, 01 Mar 2019 02:03:15 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Join-to-concatenated-tables/m-p/1550847#M3653 wenyan1206 2019-03-01T02:03:15Z https://community.qlik.com/t5/Connectivity-Data-Prep/Join-to-concatenated-tables/m-p/1550907#M3654 <P>Sorry, guys</P><P>I could solve this problem by myself.</P><P>&nbsp;</P><P>I changed the order to join or concatenate them.</P><P>1. join table C and table D</P><P>2.concatenate table B</P><P>It seems like joined tables read table b, so Join didn't work well.</P><P>&nbsp;</P><P>Thank you</P> Fri, 01 Mar 2019 06:11:52 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Join-to-concatenated-tables/m-p/1550907#M3654 wenyan1206 2019-03-01T06:11:52Z