Cross table relationship - Immediate help will be appreciated

manideep78 — Sun, 11 Jun 2017 13:45:58 GMT

Dear Community,

I have 2 tables

Table1:

Table2:

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:

I appreciate your help.

Thanks,

Manideep

Re: Cross table relationship - Immediate help will be appreciated

Sergey_Shuklin — Sun, 11 Jun 2017 16:04:49 GMT

Hello!

PFA.

You can use this script for solving this task:

CrossTable(Col1,Col2)

LOAD ID,

//,Target

FROM

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

CrossTable(Col3,Col2)

LOAD

Target

FROM

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

Left Join(t)

sorting:

LOAD Col1,

Col2 as SortLVL

FROM

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

The result will be: