Weird behavior of tables joining

Question & Answer
,
1

Hi team

I found something really strange going on with 2 tables join with the left join statetemt.
I’ve read a couple of post here and majority of similar issues were explained by how the data is being extracted by sql queries.

However, in my example, i have very simple join of 2 excel file on the date and currency fields

image
image2110×666 147 KB

As you can see, the first row is joined successfully, however, as of the second one, there’s no data joined. Does QS have any limitations in the standard account version? Have anyone faced with the similar stuff before?

Thanks

2

Hi @AndriyShepel ,
can you provide more informtion?

  1. What is your join criteria?
  2. How does the two excel files look like?
  3. How large are the tables?

There are some limitations like the size of the result dataset. Joining data - Amazon QuickSight

Best regards,
Nico

3

Hi @AndriyShepel,
It’s been awhile since we last heard from you, are you still encountering issues around your original post or were you able to find a work around?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

4

Hi @AndriyShepel,
Since we haven’t heard back, I’ll close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!