Can we concatenate (do UNION all) in quicksight? I ask as I have two datasets from two different sources , which needs to be stacked together?

Question & Answer
, , , ,
5

Hi @shrutisingh, Another Post QuickSight (and most BI tools) being read-only, we cannot insert new rows of data (can only make new columns). I think this is where your question about doing UNIONS in the data prep is probably coming from? You are right that would be a solution to the latter scenario (to insert a row with a null or 0 value), but as other mentioned the only want to to a UNION is by using Custom SQL. Yes, we are looking at adding UNIONS into the data prep UI as well, but unfortunately we cannot comment on dates :slight_smile: At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. I have tagged this as a feature request.