Delete rows in Data Load Editor

[#1]

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.

[ahmar811 · Accepted solution]

try this

Table_Name:

load *

from Table_name

where 

ITEM_GROUP_NAME <> 'Marketing';

[#3]

Thank you Ahmar, that did my job!