Forum

Notifications
Clear all

merge in PQ

3 Posts
2 Users
0 Reactions
206 Views
(@irenag)
Posts: 2
New Member
Topic starter
 

Hello, I have 3 tables: 

In table 1 I have the sum price of the product that name is 'ORANGE". The number of product is 201619038.

 name number sum
orange 201619038 95,608.13

In table 2 I have the sum price of the same product that name  'ORANGE" but it appears in two lines. The total result is the same 95,608.13.

name number sum
orange 96395665 91,575.50
orange 967844 4,032.63
total   95,608.13

In table 3 I have Conversion Table for number of product:

name the number in table 1 the number in table 2
orange 201619038 96395665
orange 201619038 967844
The question is: how can I do the merge of table 1 & 2 if I have to get to the result like this:
 name   from table 1number sum   from table 2 number sum difference
orange 201619038 95,608.13 96395665 91,575.50 4,032.63
orange 201619038   967844 4,032.63 -4,032.63

Thank you in advance

 
Posted : 26/08/2019 3:40 am
(@mynda)
Posts: 4762
Member Admin
 

Hi Irena,

Please see the attached file. However, the sum of 95,608.13 relates to the table from 1number 201619038, not the number in table two; 96395665 and therefore it is on both rows in the final table. There is no logical way you can avoid this for the second row and return a blank, as you have in your example.

Mynda

 
Posted : 26/08/2019 6:49 pm
(@irenag)
Posts: 2
New Member
Topic starter
 

Thank you!

 
Posted : 27/08/2019 3:25 am
Share: