Forum Discussion
Optional relationships
Hi Bob855 ,
Not sure if I understand the question but if you have a relationship on two tables and you want to show on the visualization the field from table 1 even if the fields in table 2 don't exist you just need to select those fields in the visualization and using right click you can show the items with no data:
Has you can see on the image above the last column refers to information on the second table and selecting the option highlited I'm abble to pick up all the fields on table 1, rest of the columns on the visualization.
Not sure if this is what you intended, if not please elaborate better on what you need to achieve.
Super UserHi Bob855 ,
Not sure if I understand the question but if you have a relationship on two tables and you want to show on the visualization the field from table 1 even if the fields in table 2 don't exist you just need to select those fields in the visualization and using right click you can show the items with no data:
Has you can see on the image above the last column refers to information on the second table and selecting the option highlited I'm abble to pick up all the fields on table 1, rest of the columns on the visualization.
Not sure if this is what you intended, if not please elaborate better on what you need to achieve.