Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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!