Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Thomasowich
Contributor II
Contributor II

Remove edges in perfect graph of data model

Hi, I have a table with 1 ID-column and 10 columns called C_1, C_1_expl, C_2,... . I would like to load each of them in a generic load, i.e. the column names are in the C_i_expl-columns. If I naively do generic loads for each i, I get 5 additional tables which are connected to eachother via the ID-column. 

So instead, I loaded the ID-column 5 times (under ID_1, ID_2,...), one for each generic load. But now I have the problem that sometimes, C_2_expl contains the same entry as C_1_expl, but they result in different tables. Is there an easy way out?

Labels (2)
1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

It sounds like you want to do a crosstable load, rather than a Generic load.  

-Rob