How to feed data from 2 tables into 1 table for every row

[Former Member]

Hi Gurus,

My flow is one BW query feeds 3 tables values get populated after huge calcuations

let say my data is as follow for the 3 tables.

T1

C1 C2 C3

Row1 10 20 30

Row2 40 50 60

Row3 70 80 90

T2

C1 C2 C3

Row1 10 20 30

Row2 0 0 20

Row3 1 2 1

My data in 3rd table should look like this

T3 = T1*T2

C1 C2 C3

Row1 100 200 300

Row2 0 0 160

Row3 70 80 90

When I create C1 C2 and C3 into table T3 where I give expression to fill C1 #ID[tablevalT1]C1 * #ID[tablevalT2]C1. It just does the first row as i gus that is the default selected row. How can I make it do for every row, without selection option

Thanks in advance

Ali

[Former Member]

Hi

If you have columns which are common in both the tables, then use 'UNION' operator to join these two tables. Select the fields which you want to in the third table. then create the third table. You will get required result.

Regards

Sandeep

[Former Member]

Sandeep,

Thanks for your response,

The table 1 2 and 3 have custom feilds that are not there in the BW query, I am facing 2 problems when trying to use the union operation,

1)these custom feilds are not recognised by the union operator

2)Union operator is not possible between 2 tables

please let me know, if I can make this work any other way