Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Delete rows in Data Load Editor

Hi all,

I am currently working in Qlik Sense and i am wondering how to delete certain rows in the data load editor. My specific example is that i want to delete all rows where ITEM_GROUP_NAME = 'Marketing' - can any of you tell the right syntax for doing that?

Looking forward to reading your answers.

Thank you in advance!

Nicolai.

1 Solution

Accepted Solutions
ahmar811
Creator III
Creator III

try this

Table_Name:

load *

from Table_name

where 

ITEM_GROUP_NAME <> 'Marketing';

View solution in original post

2 Replies
ahmar811
Creator III
Creator III

try this

Table_Name:

load *

from Table_name

where 

ITEM_GROUP_NAME <> 'Marketing';

Not applicable
Author

Thank you Ahmar, that did my job!