Second table columns not showing on JOIN

When I try to Join my direct query to my SPICE dataset, it only shows the left table on the left join. Now I will say that both tables have about 7 million rows of data. One is using the Query option from Athena and the other SPICE. Originally, I created a dashboard from one dataset then realized I needed the full timestamp which wasn’t showing in the original. For some reason Excel would visually show 9/5/2015 1:30 when it really was 9/5/2015 1:30:00 PM. I extracted the time stamp into a new column within excel. I formatted the excel column as a string to show the AM and PM in the original and upload another dataset. The goal was to Join the two datasets and Grab the newly created column in which I extract the timestamp. If you know a better way the let me know :slight_smile:

HI @velben27,
It seems as if there are no matches happening during the left join. Can you give more information on the fields you are using for the join? Perhaps a screenshot.