Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Linking Tables (loop)

Hello community,

Attached you find a file with the table view of my tables.

There are two main tables: Customersheet and Hatcherysheet.

The customer sheet got a field: CLIENT, however the hatcherysheet got 5 fields with CLIENT (1CLIENT, 2CLIENT, 3CLIENT, 4CLIENT, 5CLIENT). I created a Crosstable of these five fields to create one: CLIENT.

When I run the script it gives me an error that this crosstable is 'loosely' connected, which basically means it isn't

How do I get the field CLIENT to match with those crosstable directly, or... option 2, how do I get CLIENT field in the CustomerSheet to be linked to the 5 fields mentioned above?

Cheers guys!

Jarl.

5 Replies
Not applicable
Author

Hi Jarl,

I think the best way to do it is to use Link Tables,

How did you connect the 5 tables to form hatcherysheet? did you use concatenate load?

Not applicable
Author

Charles, thanks for helping out.

All the tables I loaded in a simple LOAD fashion.  See below this message the table order load.

Please advise on what you mean Link Tables and how to do it? I thought making the variable name the same was sufficient.

HATCHERYSHEET:

LOAD
ID2

[...],

CLIENTHATCH:

CrossTable(Clients, CLIENT)
LOAD ID2,
   
[1CLIENT],
    
[2CLIENT],
    
[3CLIENT],
    
[4CLIENT],
    
[5CLIENT]

THEN TWO OTHER CROSSTABLES ON ID2:

CrossTable(Incubator, Data)
LOAD ID2

[...]

CrossTable(Hatcher, Data2)
LOAD ID2,  [...]

CUSTOMERSHEET:

LOAD 

[...]

CROSSTABLE FOR CUSTOMERSHEET:

CrossTable(Origen, N_Poults_Origen)
LOAD
     ID
,
    
SEK,

Not applicable
Author

Bump. Charles or anyone else can help me with the above problem.

Thanks.

Not applicable
Author

Hi jarl,

can you attached a sample qv file?

Not applicable
Author

Thanks Charles, I have added two excel documents and the qvd file.

I wish that when I click on a name in the box: Client, the correct % hatch of set, and % mortality shows up. In addition to the crosstable of the hatchers I have used.

Any help is welcome.

Jarl.