Not applicable
2015-09-24
04:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Tags:
- delete_rows
8,747 Views
1 Solution
Accepted Solutions
ahmar811
Creator III
2015-09-24
05:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this
Table_Name:
load *
from Table_name
where
ITEM_GROUP_NAME <> 'Marketing';
2 Replies
ahmar811
Creator III
2015-09-24
05:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this
Table_Name:
load *
from Table_name
where
ITEM_GROUP_NAME <> 'Marketing';
Not applicable
2015-09-24
06:22 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you Ahmar, that did my job!
7,929 Views