How to remove rows after load (part 2)

[#1]

hi,

someone already asked this question but it remains unanswered and the disussion is locked. So I am coming back to this with an example.

I am using the following table:

numero	DA
1	Goldorak
2	Candy
3	DBZ
4	DBGT
5	Nicky Larsson
6	Bugs Bunny
7	Captain Flam
8	Albator
9	Avatar ANG
10	Avatar Kora

I used the followin code:

dan:

LOAD numero,

     DA

FROM

(ooxml, embedded labels, table is Sheet1);

dan2:

load *

resident dan

where DA<>'Candy';

the idea is to load, and then reload without one row. quite simple, but it doesn't work. Table dan is created but dan2 is not, and I have no processing error. It's like everything related to dan2 is ignored. Your help is welcome.

Pierre

[swuehl · Accepted solution]

Your dan2 tables gets autoconcatenated to dan table:

dan2:

NOCONCATENATE load *

resident dan

where DA<>'Candy';

DROP TABLE dan;

[alexandros17]

this is the script you need, when you load dan2 it concatenate dan1 so you must write:

dan2:
NoConcatenate
load *

resident dan

where DA<>'Candy';
DROP Table dan;

[#4]

thanks all of you for your quick answers!

[awhitfield]

Hi Pierre,

take note of the noconcatentate and drop statements in BOLD

dan:
Load * Inline
[
numero, DA
1, Goldorak
2, Candy
3, DBZ
4, DBGT
5, Nicky Larsson
6, Bugs Bunny
7, Captain Flam
8, Albator
9, Avatar ANG
10, Avatar Kora
];

NoConcatenate
dan2:

load *

resident dan

where DA<>'Candy';

Drop Table dan;

Andy