Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
migueldfr_23
Creator
Creator

How to delete data in QLIK came from aws

Hello folks, 

I am facing a issue with some ids I don't want to use, they came from AWS.
I have to delete all of them in QLIK.
I have entered a query, but doesn't do anything, because I am still seeing the id in Table...so I don't how to continue.

SELECT distinct
	id,
    name
FROM Aws. "t"."a"
where id NOT IN (
        '0010900000WjwOIAAZ',
        '0016N00000e8bsSQAQ',
        '0010900000hpiHqAAI',
        '0016N00000OiZ7tQAF',
        '0010900000hqqOIAAY',
        '0010900000iLdNYAA0',
        '0010900000hnX2lAAE',
        '0010900000YRwwYAAT'
    );

  

Thank you for help

0 Replies