Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I have 3 tables, like this example:
the main table has a one to many relationship with the Entity and also with the Country table.
I am trying to have a table visual something like this:
Visual Table | ||||
id | type | status | Entity | Country |
1 | contract | Pending | Visa | France |
1 | contract | Pending | HTC | Spain |
1 | contract | Pending | BFN |
The problem is when i am adding the fields to the table, as soon as i add the field country, when i already have the Entity, i receive the error message: Can't determine relationship between fields
I know that the country France or Spain, does not have a direct relation to any of those Entities, only to the main id.
Is there anyway to be able to have both fields in the same table??
Thanks.
The question is that there is no relation between country and Entity. The only relation that exists is with document id =1 having multiple entities (3 in this case) and with 2 countries.
It apears that i have no option to have a visual table that permits extract to excel this information of multiple fields that have relation with document id but not among them.
What I am asking is, how do you know which Entity goes to each Country? Like in that table you made, you had certain Entities aligned to countries - how do you know which go together?
Proud to be a Super User! | |
i dont know, because, is just a list of entities and a list of countries per id. the only way that i have accomplished is to concatenate the list of entities and the list of countries and present that in a table with single row for id=1.
id | type | status | Entity | Country |
1 | contract | Pending | Visa; HTC; BFN | France; Spain |
i was wondering if existed any other way of listing in as many rows as the number of entities or countries.
Right now, in your table that you would like to have, it looks like Visa Entity is for France and HTC is for Spain.... how do you know that? Once we figure out how that is determined to begin with we can brainstorm the best way to tackle it.
Proud to be a Super User! | |
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |