Forum Discussion
Remove Duplicate Datasets
- 9 years ago
Please check below,
for examples:
ID Name Date Item Description Cash Amount
1 A 1/1 Apple $5
1 A 1/1 Apple $5
1 A 1/2 Apple $5
Above is the sample of my dataset. So i wanna make sure i remove those repeat rows (for e.g the 1st and 2nd row) which are having exact same ID, Name, Date, Item description and Cash Amount. I had tried to concenate those columns however it doesnt work as the data type are different (some are text, some are number).
Please check below,
- Anonymous5 years agoNot applicable
how to remove duplicates from 2 different data sources