0

Auto join not done on load

Hello, While loading datasets from attached Excel tabs using Schema Wizard, the tables are created and also data loaded BUT  the join between the tables (e.g order / order_details) is not automatically detected.  Pls check attached files. We are using default installation for learning using Derby db

Please suggest if we are missing something

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Just manually create the child joins from the schema, for eg order_details will be the child and order will be the parent so create a child join from details to the header on the key columns of the parent.

    Like 1
    • Amit Kothari Thanks for your reply. Yes, we did do manual joins and that worked; but I thought the option to "Automatically Detect Joins" would do that automatically.  

      Like
    • Sujit Sarkar That is if the foreign key constraints are already defined in the database, then Incorta can read that and import them in.

      Like
Like Follow
  • Status Answered
  • 1 yr agoLast active
  • 3Replies
  • 114Views
  • 2 Following