topic Wrong sales value for last year after concatenate the table with current year table in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Wrong-sales-value-for-last-year-after-concatenate-the-table-with/m-p/1547382#M3642 <P>Hi,</P><P>I have several csv. files for different years. When I associate the sale.order 2018 and sale.orderlines 2018 the sales is <STRONG>16102 units </STRONG></P><P>but when I add the sale.order 2019 and sale.ordelines 2019 as well, which qlik automatically concatenates them because they have the same fields names, the value for 2018's sale will increase to <STRONG>17678 units</STRONG>. I have read that concatination in qlik will only join the tables together, but in my case, most probably during concatination some extra rows of data is created. Do you have any suggestion, how can I get the accurate sale number?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Associations.jpg" style="width: 456px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/6485iA1D084250E37DAD1/image-dimensions/456x362?v=v2" width="456" height="362" role="button" title="Associations.jpg" alt="Associations.jpg" /></span></P> Thu, 21 Feb 2019 10:32:29 GMT Masha2280 2019-02-21T10:32:29Z Wrong sales value for last year after concatenate the table with current year table https://community.qlik.com/t5/Connectivity-Data-Prep/Wrong-sales-value-for-last-year-after-concatenate-the-table-with/m-p/1547382#M3642 <P>Hi,</P><P>I have several csv. files for different years. When I associate the sale.order 2018 and sale.orderlines 2018 the sales is <STRONG>16102 units </STRONG></P><P>but when I add the sale.order 2019 and sale.ordelines 2019 as well, which qlik automatically concatenates them because they have the same fields names, the value for 2018's sale will increase to <STRONG>17678 units</STRONG>. I have read that concatination in qlik will only join the tables together, but in my case, most probably during concatination some extra rows of data is created. Do you have any suggestion, how can I get the accurate sale number?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Associations.jpg" style="width: 456px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/6485iA1D084250E37DAD1/image-dimensions/456x362?v=v2" width="456" height="362" role="button" title="Associations.jpg" alt="Associations.jpg" /></span></P> Thu, 21 Feb 2019 10:32:29 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Wrong-sales-value-for-last-year-after-concatenate-the-table-with/m-p/1547382#M3642 Masha2280 2019-02-21T10:32:29Z