Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?
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,
Bump. Charles or anyone else can help me with the above problem.
Thanks.
Hi jarl,
can you attached a sample qv file?
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.