Skip to Content
0

HCI DS Combine two tables data in one data flow to output

Oct 21, 2017 at 02:14 AM

146

avatar image
Former Member

Hi,

I have two ratio tables and i would like to combine the data in HCI data flow to calculate another key figure based on ratios. I have tried left outer join from one table but not all combinations exist in that table. Any ideas on how to combine two sap tables data to one output and update IBP?.

Regards

SG

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Oct 31, 2017 at 10:26 PM
0

Hi,

there is no union join available in HCI. However you can achieve the same using row gen with 2 different number ranges merging on to the tables to combine them to one table.

Note: this will be a very performance intensive when the volume of data increases.

Share
10 |10000 characters needed characters left characters exceeded