Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Aleja54
Contributor
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 (1)
  • ETL

1 Solution

Accepted Solutions
rogerpegler
Creator II
Creator II

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.

View solution in original post

1 Reply
rogerpegler
Creator II
Creator II

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.

View solution in original post