Joining three or more tables

[Huanna]

Hi guys ,

 I'm trying  to do Left join in three tables,  I need to relate the "Sequencia" and bring the "Ganho" .  The "Ganho" field of the tables has no relation, only "Sequencia",  but in the second Join  the script doesn't  have the "Ganho" value, I believe it is comparing with the "Ganho" field of the first join. 

I need the "Ganho" values to be in the same field.

help me please!!

Series_definições:
CrossTable(Fase, Sequencia, 5)
LOAD
HUB,
Época,
Polo,
"Ano da Campanha",
"Inoculação de Seedlings",
"Fase 1 - Avaliação",
"Fase 1 - Seleção",
"Fase 2",
"Fase 3",
"Fitoteste Carvão e Mosaico",
"Fitoteste Ferrugens",
"Fase 4"
FROM [lib://MGC/Séries_definições.xlsx]
(ooxml, embedded labels, header is 6 lines, table is [Sequências das séries]);

Left Join(Series_definições)
LOAD
SEQ2 as Sequencia,
Ganho
FROM [lib://MGC/3. Fase 1/KPI31/testes-huanna/dtf_GanhoTPH.xlsx]
(ooxml, embedded labels, table is dtf_GanhoTPH);

Left Join(Series_definições)
LOAD
SEQ2 as Sequencia,
Ganho
FROM [lib://MGC/6. Fase 4/KPI33/dtf4_GanhoTPH.xlsx]
(ooxml, embedded labels, table is dtf4_GanhoTPH);

[vvira1316]

Hi,

What is the problem you are running into? Will you be able to share Sample data files?

you may want to understand how cross table load works in qlik. Please refer to following link.

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/LoadData/wor...

[Huanna]

Hi,

I'm not having problem  with crosstable , I'm not seeing the "Ganho" values of the second Join. I need it to match the sequence number and bring the "Ganho" value in both Join.

First Join result:

SecondJoin result:

Does not bring the "Ganho" values.

Thanks!

[Vegar · Accepted solution]

You are absolutely correct in your analysis, you are joining on the Ganho-value in the second join.

Try this.

Series_definições:
CrossTable(Fase, Sequencia, 5)
LOAD
HUB,
Época,
Polo,
"Ano da Campanha",
"Inoculação de Seedlings",
"Fase 1 - Avaliação",
"Fase 1 - Seleção",
"Fase 2",
"Fase 3",
"Fitoteste Carvão e Mosaico",
"Fitoteste Ferrugens",
"Fase 4"
FROM [lib://MGC/Séries_definições.xlsx]
(ooxml, embedded labels, header is 6 lines, table is [Sequências das séries]);

Ganho:
LOAD
SEQ2 as Sequencia,
Ganho
FROM [lib://MGC/3. Fase 1/KPI31/testes-huanna/dtf_GanhoTPH.xlsx]
(ooxml, embedded labels, table is dtf_GanhoTPH);

Concatenate (Ganho)
LOAD
SEQ2 as Sequencia,
Ganho
FROM [lib://MGC/6. Fase 4/KPI33/dtf4_GanhoTPH.xlsx]
(ooxml, embedded labels, table is dtf4_GanhoTPH);

Left Join(Series_definições) 
Load * FROM Ganho;
DROP TABLE Ganho;

[Huanna]

It worked, thank you so much for the help!!