Forum Discussion
CREATE A TABLE - challenge
Hi!
I have 3 tables (Datasets) as the ones on the top (A, B and C).
And I created a Visualization Table in PBA as the one on the left corner.
How can I create the orange Visualization Table needed?
Hi Anonymous,
You have a problem in your data. I assume you have built your VISUALIZATION TABLE using the many-to-many relationship between the Table A and Table B. But if you take a close look at Shelly from Marketing in the Table A, you will see that there are two entries in the Table B which can be applied to her: Manager-Marketing and Relationships-Marketing.
You can close your eyes, ignore this duality and solve your case with the crazy measure below, but I won't recommend doing that - it would be better to double check your data model.
Best Regards,
Alexander
1 Reply
Hi Anonymous,
You have a problem in your data. I assume you have built your VISUALIZATION TABLE using the many-to-many relationship between the Table A and Table B. But if you take a close look at Shelly from Marketing in the Table A, you will see that there are two entries in the Table B which can be applied to her: Manager-Marketing and Relationships-Marketing.
You can close your eyes, ignore this duality and solve your case with the crazy measure below, but I won't recommend doing that - it would be better to double check your data model.
Best Regards,
Alexander