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'
);