Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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';

View solution in original post

Not applicable
Author

Thank you Ahmar, that did my job!