Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do you mean delete record from the source??
QlikView is meant for viewing (as the name already says) ...
Think the only way of achieving some deletion is by using Macro's.
Or did you mean deleting records from the loaded data in QV?
In this case ... why loading the data if not needed??
I'm refereng to delete data on QV database.
Like on Call Center Demo
From Excel: DynamicUpdateCommand (SQL), but I want to do the same from QV Script (Not under Excel Macro)
Best regards
It's a question to know possibilities under the same system.
I'm with A Fuchten. Just don't load the data. When loading, exclude the data you don't want in the QV database (cloud). Use WHERE-clauses for instance. Or when joining tables, don't use OUTER JOIN, but LEFT, RIGHT or INNER JOIN, ...
Data is loaded on the system, and I have detected some mistakes on data.
I want to reload the new data (only data with mistakes corrected).
Then, I have to delete erroneous data and concatenate the new one.
Hi Jope,
How can you identify the erroneous records? Could you describe it?
Best regards.
After verify original database, there is a field with identificator.
Then I have a Key on old table 'EXP'
I want to del records on QV table with that EXP numbers and then concatenate the new ones.