Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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.

    Add comment
    10|10000 characters needed characters exceeded