I am having trouble joining two datasets. One is .xlsx and the other is a sql query. the data types are the same and I know for a fact that there are matching records but no records are returned. Each dataset works fine independently in its own analysis. What could be causing this?
Hello @dspringer, your JOIN conditions require records from .xlsx and SQL query to have matching values in both customer ID and product ID, but when I look at the table previews, neither the customer ID or Product ID seem to match, which is probably why no record is returned.
customer ID: 901036 — 1 # not match
product ID: 1001893 — 908440 | 908441 | 908450 # not match
they do have matching records just as i stated in my post just none are visible in the screenshots. Removing and re-adding the tables worked for some reason.
Thank you, @dspringer for your response. Glad to hear you managed to solve it by re-adding the table. Let me know if you need any other assistance, otherwise I will close out this topic.