I got a question again I try to do an OLAP table where I need to combine data from different tables.
I try to explain the case as good as I can. In my table “T052U_BSEG” I got the column named “TEXT1” (here is a description in each column) and the column “ZTERM” (here i an ID which is unique for each different description, but a description can come up multiple time).
On the other hand I got the table “PB_CLAR” where I got two columns with the ID’s from ZTERM in it. I want to create a column in an OLAP table that the ID in “PB_CLAR” look up the ID in the “T052U_BSEG” and pull the right description from “TEXT1”
Thank you guys in advance