Crosstable, Crossjoin Script

[#1]

Hello,

I am trying to write a script which will combine data from multiple inputs, calculate columns and load a final table.

Please refer to the attached excel and give your suggestions.

Thanks.

[el_aprendiz111]

hI,

Directory;

CrossTable(Days, Data, 2)

INPUT_1:

LOAD * FROM

[..\..\..\..\..\..\..\Desktop\web_Qlik\Crosstable,Crossjoin.xlsx]

(ooxml, embedded labels, table is Input1);

INPUT_2:

LOAD * FROM

[..\..\..\..\..\..\..\Desktop\web_Qlik\Crosstable,Crossjoin.xlsx]

(ooxml, embedded labels, table is Input2);

Right Join

LOAD * Resident INPUT_1 Where Data>0; DROP Table INPUT_1;

[#3]

Thanks for your suggestion.

The solution does not restrict the output to pick only the November's data. Can we use any other column to identify the month as November?