Solved: Merge/Append 2 Tables - Qlik Community

Report Inappropriate Content · ‎2010-10-22

I'm havign a transactional Table

Year / Month/ Day / Company / Product / Items / NetSales / Client

In e Second Table i'm having

Year / Month / Company / Product / Forecast_NetSales

I would like to Merge the 2 tables, a simplex join doesn't work becasue we are getting a carthesias product ..

I know i could extract only Year/Month/Company/product from the first and create a such 2 tables, but is there a way to get it all in One. Ok, for some records the Customer will be NULL end for the forecast lines the items en netsales will be null.

Miguel_Angel_Baeyens · ‎2010-10-22

Hello Harry,

If you want to just append the records from the second one to the first one, use CONCATENATE keyword so

Table:LOAD Year, Month, Day, Company, Product, Items, NetSales, ClientFROM File.QVD (qvd);CONCATENATELOAD Year, Month, Company, Product, Forecast_NetsalesFROM File2.QVD (qvd);

Hope that helps!

View solution in original post

Miguel_Angel_Baeyens · ‎2010-10-22

Hello Harry,

If you want to just append the records from the second one to the first one, use CONCATENATE keyword so

Table:LOAD Year, Month, Day, Company, Product, Items, NetSales, ClientFROM File.QVD (qvd);CONCATENATELOAD Year, Month, Company, Product, Forecast_NetsalesFROM File2.QVD (qvd);

Hope that helps!

Report Inappropriate Content · ‎2010-10-22

I thought that concatenate wa only when exaclty the same records.

Subperb !!