Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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:

Component

ComponentGroupName
11Component1
21Component2
31Component3
42Component4
52Component5
64Component6
74Component7

Group

GroupHeader 1
1Group1
2Group2
3Group3
4Group4

Is this possible?

0 Replies