Join Two Table Data

[girish_talele]

Dear Experts,

I want to join two tables, first contains Bill Of Material & second contains Order Issue Data.

I want to compare Required v/s Actual Issue data.

The Data in BOM & Order Issue is as given below:-

Resulting table required as given below:-

Please help in the same.

[#2]

The result is comes by joining the two tables

By using Outer join we can get the above Result

[mjayachandran]

Check attached :

Just use Outer join

[girish_talele]

Dear Sasikumar & Mahesh,

By Outer Join or making common field, the data is not getting arranged in desired manner.

For each row of first table, second tables all rows are getting repeated. And hence the 60 rows are populated.

Any other solution ???

[jagan]

Hi,

Try this script

BOM:

Load

P_MatId,

P_PrdNo,

P_MatId  & P_GICompId AS Key,

P_GICompId,

P_CompGIQty

Inline [

P_PrdNo, P_MatId, P_GICompId, P_CompGIQty

Ord1, Mat1, Comp1, 10

Ord1, Mat1, Comp2.1, 20

Ord1, Mat1, Comp3, 30

Ord1, Mat1, Comp4, 40

Ord1, Mat1, Comp4.1, 40

Ord2, Mat2, Comp5, 50

Ord2, Mat2, Comp6.1, 60

Ord2, Mat2, Comp7, 70

Ord2, Mat2, Comp8, 80

Ord2, Mat2, Comp8.1, 80

Ord3, Mat1, Comp1, 10

Ord3, Mat1, Comp2.1, 20

Ord3, Mat1, Comp3, 30

Ord3, Mat1, Comp4, 40

Ord3, Mat1, Comp5.1, 40

];

LEFT JOIN

Load * ,

B_MatId  & B_CompId AS Key

Inline [

B_MatId, B_CompId, B_CompReqQty

Mat1, Comp1, 10

Mat1, Comp2, 20

Mat1, Comp3, 30

Mat1, Comp4, 40

Mat2, Comp5, 50

Mat2, Comp6, 60

Mat2, Comp7, 70

Mat2, Comp8, 80

];

Regards,

Jagan.

[girish_talele]

Dear Jagan,

The Join is not Woking, e.g in Left Join the "Comp2" is missing.

[girish_talele]

Dear Experts,

Any other solution???

[saradhi_it]

Did you used force concatnation

[girish_talele]

No,

How to use force concatenation.

Please suggest.

[saradhi_it]

concatenation won't work for u r requirement use straight table that is best...bcos you can shift rows as you want,,,,,,