Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a data table based on months and country/region
i have another forecast table that I want to join the columns onto to make a final table like below
how do I do this
Hi.
Have you tried to concatenate the tables like:
LOAD a, b, c from table1.csv;
concatenate LOAD a, c from table2,csv;
table 1 :
load * from ..;
join
table2 :
load * from ..;
only thing to have tis working is making sure that the country field has the same NAME in both tables (qlik is case sensitive)