Cross table relationship - Immediate help will be appreciated

[manideep78]

Dear Community,

I have 2 tables

Table1:

ID	A	B	C	Target
1	A1	B1	C1	Yes
2	A1	B1	C1	No
3	A1	B1	C1	Yes
4	A1	B2	C1	No
5	A1	B2	C1	Yes
6	A2	B2	C2	Yes
7	A2	B2	C2	Yes
8	A2	B2	C2	No
9	A2	B3	C2	No
10	A2	B3	C3	No
11	A2	B3	C3	No
12	A2	B3	C3	Yes
13	A3	B3	C4	No
14	A3	B4	C4	Yes
15	A3	B4	C4	Yes

Table2:

Col1	Col2
A	10
B	9
C	8

The columns in table 1 are rows in my table2. Each row in table 2 has some score to say whether its important to consider or not.

The output table should be like below

Output table:

Col1	Col2	Target	Count(Taget)
A	A1	Yes
		No
	A2	Yes
		No
	A3	Yes
		No
B	B1	Yes
		No
	B2	Yes
		No
	B3	Yes
		No
	B4	Yes
		No
C	C1	Yes
		No
	C2	Yes
		No
	C3	Yes
		No
	C4	Yes
		No

I appreciate your help.

Thanks,

Manideep

[Sergey_Shuklin]

Hello!

PFA.

You can use this script for solving this task:

CrossTable(Col1,Col2)

t:

LOAD ID,

     A

     ,B

     ,C

     //,Target

FROM

[https://community.qlik.com/thread/263606]

(html, codepage is 1251, embedded labels, table is @1);

CrossTable(Col3,Col2)

LOAD

Target

     ,A

     ,B

     ,C    

FROM

[https://community.qlik.com/thread/263606]

(html, codepage is 1251, embedded labels, table is @1);

Left Join(t)

sorting:

LOAD Col1,

     Col2 as SortLVL

FROM

[https://community.qlik.com/thread/263606]

(html, codepage is 1251, embedded labels, table is @2);

The result will be: