topic Re: How to remove rows after load (part 2) in QlikView

How to remove rows after load (part 2)

Fri, 03 Jul 2015 14:40:54 GMT

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,

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

Re: How to remove rows after load (part 2)

swuehl — Fri, 03 Jul 2015 14:43:13 GMT

Your dan2 tables gets autoconcatenated to dan table:

dan2:

NOCONCATENATE load *

resident dan

where DA<>'Candy';

DROP TABLE dan;

Re: How to remove rows after load (part 2)

alexandros17 — Fri, 03 Jul 2015 14:43:47 GMT

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;

Re: How to remove rows after load (part 2)

Fri, 03 Jul 2015 14:50:09 GMT

thanks all of you for your quick answers!

Re: How to remove rows after load (part 2)

awhitfield — Fri, 03 Jul 2015 14:50:19 GMT

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