Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Merge fact tables

Hello Guys,
Can anybody help me? Please! I've been trying for days and I can't.

The fCustoInvestimento table has all marketing campaign costs by date. I would like to bring to this table some columns from the fPipes table such as the 'Valor Deal', 'Etapa', 'Estrategia and 'Produto' columns.

Below is the modeling:

 

I merged the CustoInvestimento table with the fPipes table and performed the InerJoin but it ends up duplicating the rows with the s value below

The correct value would be the one in the image below. The Campaign/Ad Set/Ad from the CostInvestment table has only two rows of records in the fPipe table

I want to make just a table so I can filter by any column at the campaign/ad set/ad level by date.

 

https://ufile.io/x1zb7uvr

 

 

Need Help

3 Replies

  • VijayP's avatar
    VijayP
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Anonymous 

    Try using Left Out based on one similar column in both tables.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      VijayP I did it but it is doubling my values

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    5 years ago

    I'm not sure why you need to add columns from one table to another. In theory, if you set up the model correctly, you don't need to. I would recommend you delete the many-to-many relationship between the dCampanha table and the fact tables and create seperate dimension tables as follows:

     

     

    You can now use these dimensions for your visuals, filters slicers and measures and include fields from either table based on the common dimension.

    I've attached the sample file for you