Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
coolguy123
Contributor II
Contributor II

Adding more month columns

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 

ABF3DD3E-D82A-4E9C-9123-4318B19D2ACD.png

2 Replies
janus2021
Contributor III
Contributor III

Hi.

Have you tried to concatenate the tables like:

LOAD a, b, c from table1.csv;

concatenate LOAD a, c from table2,csv;

OmarBenSalem

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)