Understanding My Data... preventing duplicates after DataFusion and creating a Table in Analyzer
Hello, I'm new to Domo and working with data in general.
I've managed to connect my data from Greenhouse (applicant tracking system). I have a LOT of data and have used DataFusion to combine my large sets of data. That has all worked fine. I'd like to create a few tables that can be updated in real time (Example: current candidate pipelines for open requisitions, offer status etc) I noticed that there are a lot of duplicate rows when manipulating my data in Analyzer. Questions....
-How to get rid of the duplicates in Analyzer if my data is from a DataFusion?
-Why are there duplicates?? If I have my dataset update every day does it keep my historical data? How do I make sure I am getting the most up to date data??
-Do DataFusion update when the dataset updates or do I have to manually update them?