Hi,
I am trying to merge two tables with slightly different dimension values.
Table 1 Project ID Project Name 1234 Project1 5678 Project2 1122 Project3 5566 Project4 Table 2 Project ID Project Type 1234_D1 New 5678 Old 1122_D2 New 5566 NewTable 2 Project_ID has underscore in it and the result of the merge doesn't work properly.
I created another dimension:
Project_ID_2 =If(Pos([Project_ID];"_")>0;Left([Project_ID];Length([Project_ID])-3);[Project_ID])
But how can i merge Table 1 with Project_ID_2? is there another way to solve this?
Note: I'm using SAP WEBI BO