Creating Multiple Data Tables from a Single Data Source

[Matt Brown 2]

I have data source that is based off of a SQL query, and I am wanting to break that into multiple Data Tables based on certain conditions. The reason being is that I want to maintain a single SQL query file rather than have to update multiple data sources.Is there a way to do this

[Kirsten Smith (she/her)]

You can add a new data table to your analysis file and select an existing file, which makes a copy of that table. You can then add transformations or make changes to the copied table while leaving the original intact.