Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Just add the DISTINCT keyword to each LOAD.
-Rob