topic Concatenate in QlikView

Concatenate

Thu, 04 Jun 2009 16:00:53 GMT

Hi,

does someone could to post a qvw example of Concatenate statement between 2 files ?

Thanks

Concatenate

Thu, 04 Jun 2009 17:51:51 GMT

Hallo Shideh,

May be the following explanation from Oleg will help you..

The idea of concatenation is to concatenate tables (not fields!) when more than 1 table have more than key in common. For example:

load Item, Customer, Date, Order Quantity from Orders;

concatenate load Item, Customer, Date, Invoiced Quantity from Invoices;

In this example, the resulting table will store both Orders and Invoices, with the common fields Item, Customer and Date. The other two fields - Order Qiantity and Invoice Quantity will only have a value when available.

This way, you avoid synthetic keys and avoid the need in creating a Link Table. The nice thing about concatenation is that now you can also load tables with other repeating fields, for example:

Customer, Date, Budget Amount

Customer and Date will be shared fields, but not the Item.

-sravan

Concatenate

Tue, 17 Aug 2010 16:04:22 GMT

Hallo sravan

Thank you very much for your Apply.

i check it and have a niche day

Shideh

Concatenate

marcohadiyanto — Wed, 22 Dec 2010 04:12:29 GMT

http://community.qlik.com/blogs/qlikviewblogs/archive/2009/11/20/understanding-join-and-concatenate.aspx

hope this link will help you