Load File into different tables and creating PK and FK
Hi,
I have one file containing information about groups and their components, but they do not have a key to identify which components compose each group. I only know the components of the group because of the load order, f.i.
Example file:
group1
component1
component2
component3
group2
component4
component5
group3
group4
component6
component7
In this example group1 has 3 components (1,2,3), group2 has 2 components(4,5), group3 does not have any components and group4 has 2 components (6,7)
I like to load this data into 2 tables (Groups and Components) and create a PK and FK to link the components to the groups, like this:
