clean repeated records

[Aleja54]

Good afternoon,

I have a problem with the data and it has repeated records, to solve this I thought if there is a qlik statement when loading the data that come from a mysql database to avoid having to clean them from the database original that only takes care for qlik.

Very grateful to have your help

[rogerpegler · Accepted solution]

It might be better to do as part of the MYSQL query. However to do it in Qlik once it has been loaded:

NewTable:

NoConcatenate Load Distinct * Resident OldTable;

Drop Table OldTable;

Rename NewTable to OldTable;

You may also be able to apply the Distinct clause as part of the load statement preceding the MYSQL query.