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

[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

[former_member361253]

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.