Delete record on Qlickview?

[#1]

Hello all,

Can someone explain me if exist any way to delete record after loading a Table.

On QV examples it's posible to delete records from an Excel Macro, but....

How can I done the same under QV Script?

Best regards

[Miguel_Angel_Baeyens]

Hello,

You can do the following (as suggested by Anita and Mark)

1.- Load a table with all "EXP" keys you don't want to analyze in a map

NotToAnalyzeMap:MAPPING LOAD EXP, 1 AS DONT_LOADFROM OldQVTable

2.- Load from your database as follows

VerifiedInfo:LOAD Field1, Field2 WHERE ApplyMap('NotToAnalyzeMap', EXP, 0) = 0;SQL SELECT Field1, Field2 FROM Database;