CONCATENATE TABLES

[inigoelv]

Hello:

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

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

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

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

Thanks in advance.

[Sokkorn]

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 · Accepted solution]

Just add the DISTINCT keyword to each LOAD.

-Rob