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.  

    • 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 Follow
  • Status Answered
  • 2 yrs agoLast active
  • 3Replies
  • 116Views
  • 2 Following

Product Announcement

Incorta 4.9 is now Generally Available (GA)!!!