@Lisa-Chang In addition to a Data Fusion (which should do what you want just fine) Magic ETL can also combine multiple DataSets on a common key, and will also let you clean up data in other ways. To learn more, you can go to the down arrow menu -> Domo University -> Prepare -> Magic

Hi @ocrkm, Have you tried using Magic ETL? You can use the "Set Column Type" action on that column, tell it that it is a date, and tell it that it is month first (as some countries use DD/MM/YYYY for dates). You can set the job to run every time you get new data in Domo then use the resultant, cleaned up DataSet to power…