Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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?