Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yucel_ozer
New Contributor II

Joining Tables

Dear Friends,

I have two tables.

When I select 'class1' field from Table1, the duration values of a, d  and x should be selected  via 'comp' field from Table2.

When I select 'class2' field from Table1, the duration values of b, e  and y should be selected  via 'comp' field from Table2.


The same things for other fields...

How can I join these tables ?

Thanks for kind reply in advance.

Regards.

 

Table1Table2
classcomp1comp2comp3studentcompduration
class1adxstudent1a40
class2beystudent2b50
class3cf student3c30
class4 g student4d60
e56
f55
g59
x63
y67
z35
s71
m75
n79
v83
t49
2 Replies
cka
Contributor

Re: Joining Tables

You would want to use the CROSSTABLE function: https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/LoadData/work-with-cross-tables.h...

Your script should look something like this:

Table1:

CrossTable(Comp#, Comp,2)

Load Class, Student

From filename.xls;

Table2:

Load Comp, Duration

From filename2.xls;

yucel_ozer
New Contributor II

Re: Joining Tables

Thanks for your help Serina.

Regards

Community Browser