topic Merge/Append 2 Tables in QlikView

Merge/Append 2 Tables

Fri, 22 Oct 2010 13:20:42 GMT

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.

Merge/Append 2 Tables

Miguel_Angel_Baeyens — Fri, 22 Oct 2010 13:25:03 GMT

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!

Merge/Append 2 Tables

Fri, 22 Oct 2010 14:40:09 GMT

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

Subperb !!