Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to remove rows after load (part 2)

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:

 

numeroDA
1Goldorak
2Candy
3DBZ
4DBGT
5Nicky Larsson
6Bugs Bunny
7Captain Flam
8Albator
9Avatar ANG
10Avatar 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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Your dan2 tables gets autoconcatenated to dan table:

dan2:

NOCONCATENATE load *

resident dan

where DA<>'Candy';

DROP TABLE dan;

View solution in original post

4 Replies
swuehl
MVP
MVP

Your dan2 tables gets autoconcatenated to dan table:

dan2:

NOCONCATENATE load *

resident dan

where DA<>'Candy';

DROP TABLE dan;

alexandros17
Partner - Champion III
Partner - Champion III

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;

Not applicable
Author

thanks all of you for your quick answers!

awhitfield
Partner - Champion
Partner - Champion

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