topic CONCATENATE TABLES in QlikView

CONCATENATE TABLES

inigoelv — Wed, 05 Jun 2013 00:01:28 GMT

Hello:

I would like to concatenate these tables without duplicate the common rows:

It is possible an example with the field date and sentence where, like "where Date > Max(Date)".

Thanks in advance.

Sokkorn — Wed, 05 Jun 2013 01:51:49 GMT

Hi,

I think JOIN may do this job. Let try

[Data1]:

LOAD * Inline [

Article, Date, Quantity

A, 01/02/2013 12:34:23, 100

B, 01/02/2013 13:36:45, 200

C, 01/02/2013 13:38:56, 300

D, 01/02/2013 13:43:46, 400];

[Data2]:

JOIN ([Data1])

LOAD * Inline [

Article, Date, Quantity

C, 01/02/2013 13:38:56, 300

D, 01/02/2013 13:43:46, 400

E, 01/02/2013 13:48:45, 345

F, 01/02/2013 14:45:23, 600

G, 01/02/2013 14:49:45, 789];

Regards,

Sokkorn

rwunderlich — Wed, 05 Jun 2013 02:56:05 GMT

Just add the DISTINCT keyword to each LOAD.

-Rob