How to add additional joins in worksheet schema

How will worksheet schema be established as we build that? Can we be able to add new join? Note: I am not referring to updating an existing join

 

Here is an issue I am trying to solve. We have a table ‘Table A’which has a FK relation with 'Table 1' as well as 'Table 2'. When I look at my existing worksheet, I see a join between 'Table A' & 'Table 1', but not with 'Table 2'. I tried to create another worksheet that has a join between 'Table A' & 'Table 2'. I think we need both the joins established within a worksheet schema in order to show lets say balance which comes from 'Table A' by different levels based on where attribute comes from like Table 1 or 2. How can we do that? Any help is greatly appreciated. Thank you.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • are all tables included in the same worksheet? 

    if there are no columns from table 2 in your existing worksheet then the join will not sure in the schema view. 

    Reply Like
Like Follow
  • 3 mths agoLast active
  • 1Replies
  • 20Views
  • 2 Following