Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning;
I ma making one incremental load where I insert new rows, updated rows and eliminate rows.
The problem is the base is not complete, because for saving espace in the server has one limitation of rows. It means the old ones are little by little being erased.
I need maintain in the Completed Base the old ones.
The script used is:
Base:
LOAD * INLINE [
PrimaryKey, ART_CODICE, QUANTITA
2, B, 2
4, D, 4
6, E, 6
7, F, 7
];
concatenate
LOAD * INLINE [
PrimaryKey, ART_CODICE, QUANTITA
1, A, 1
2, B, 2
3, C, 3
4, D, 5
6, E, 6
] WHERE NOT Exists(PrimaryKey);
inner join
LOAD * INLINE [
PrimaryKey, ART_CODICE, QUANTITA
2, B, 2
4, D, 4
6, E, 6
7, F, 7
] where PrimaryKey>2;
In theory I expect:
PrimaryKey | ART_CODICE | QUANTITA |
1 | A | 1 |
2 | B | 2 |
4 | D | 5 |
6 | E | 6 |
7 | F | 7 |
Thanks in advance