Load File into different tables and creating PK and FK

Thu, 26 Sep 2013 13:33:07 GMT

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:

Component

Component	Group	Name
1	1	Component1
2	1	Component2
3	1	Component3
4	2	Component4
5	2	Component5
6	4	Component6
7	4	Component7

Group

Group	Header 1
1	Group1
2	Group2
3	Group3
4	Group4

Is this possible?

topic Load File into different tables and creating PK and FK in QlikView

Load File into different tables and creating PK and FK