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.

    Reply 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.  

      Reply 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.

      Reply Like
Like Follow
  • Status Answered
  • yesterdayLast active
  • 3Replies
  • 14Views
  • 2 Following

Welcome!

Welcome to Incorta's user community! Whether you are already an Incorta customer, or interested in becoming one, this is your place to come together and discuss the software, register for webinars, learn about events, learn about new product releases and get support from the community.