0Auto 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
-
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.
-
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.
-
