How to use SQL query to create new dataset from existing dataset?
I haven’t seen that done before. I have used a dataset in another dataset, added calculations and filters.
I’ve only joined an existing dataset visually to other custom SQL sources of data (or other datasets) using the big blue “add data” button up in the upper right corner. I don’t know how well I’m describing this, but let me try. We have a dataset that pulling from multiple datasources. Each Custom SQL on a data source is it’s own entity, and one can then join visually matching field from two different custom SQLs, with inner, left, right, or full outer joins defined between the two custom SQLs.