Forum Discussion
mflorian
8 years agoFrequent Visitor
Wrapping Distinct around a union
I have created three summary tables that pulls revenue information from three disparate systems for a consolidated report. Two of the tables have the potential for duplicate data due to a data classi...
- 8 years ago
Hi,
You may append data using Query Editor and then select all column > Right click > Remove Duplicates > Close and Load.
Ashish_Mathur
8 years agoSuper User
Hi,
You may append data using Query Editor and then select all column > Right click > Remove Duplicates > Close and Load.
- pobaldi3 years agoNew Member
If I do remove duplicates that way, and then refresh all my union'ed data sources and add rows, etc. will the duplicates be removed on the refreshed data source as well?
- Ashish_Mathur3 years agoSuper User
Yes