Are join clauses not working currently?

Q&A
, ,
1

Hey I am trying to use the join clause where one dataset includes a set of employee logins and i want to join it with another dataset with has both the employee logins and the manager logins. the goal is to join them such that the employee logins will be linked to the corresponding manager login. However, I have tried it using many different data sources and it never works, showing an unhelpful error symbol.

I’ve played around with all the options, left link, center link, right link etc. but they all show the unhelpful error.

Are there limitations to this feature on Quick Sight? Does the employee login have to be in teh same column for both datasets or some other criteria?

Thanks for any help

Screenshot 2025-10-02 132647
Screenshot 2025-10-02 1326471560×922 51.1 KB

2

As a temporary solution, I have instead uploaded the same data but as an excel file and the join clause works if its an excel file… but i am still interested in doing it using the data source directly from hoot/data central

3

Hi @hrryln

Apologies for the delayed response!

Please check that you are not exceeding any row or size limits, especially for joins across data sources or with large datasets.

Verify that column data types and values are an exact match, as errors often result from type mismatches or null values.

If you want to join across different data sources, the result must be a SPICE dataset.

Please refer to the below Quick Suite documentations and community post this might be helpful for you.

4

Hi @hrryln,

Following up here as it’s been awhile since we last heard from you on this thread; did you have any additional questions regarding your initial post?

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

Thank you

5

Hi @hrryln,

Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you