Union union all issue

is there a work around to union all data other than custom sql its not allowed for me both data are tables on Redshift cluster

Hi @zeyad1 and welcome to the QuickSight community!
QuickSight does not have a great way/out of the box feature to perform a union between datasets.
Have you tried completing the union at the database layer in Redshift?

Hi @zeyad1

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

Yes thanks team i did that at database level
Regards

1 Like

Hi @zeyad1

Thank you for the confirmation.