Discussion Board for collaboration on QlikView Scripting.
would you have reference to a clean up script to remove 'quasi-duplicates' in a straight table ?
Field1 Field2 Field3
Val1 Val2 name
Val1 Val2 name.
Val1 Val1 Val1
Val1 N/A N/A
QU1. from BI point of view: what clean up makes sense in sales database when it comes to clean account entries (this is a general and open question) ?
QU2. would you have script to perform the two above operations in example, or other simple clean up operations ? also simple script for duplicates removal ?
Please use DISTINCT key word after LOAD statement to avoid the duplicate rows.
LOAD Field1, Field2, Field3 FROM SOURE1;
LOAD Field1, Field2, Field3 FROM SOURE3;
LOAD DISTINCT * Resident TEMP ;
DROP Table TEMP;