Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Aleja54
New Contributor

clean repeated records

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

Labels (2)
1 Solution

Accepted Solutions
rogerpegler
Contributor

Re: clean repeated records

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.

1 Reply
rogerpegler
Contributor

Re: clean repeated records

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.