I'm working to automate the process of cutting surveys. I currently have an Alteryx workflow that arranges my data in such a way that it displays as a flat file in Tableau. However, the process of creating a new worksheet for each question and moving the appropriate dimensions into Rows and Columns is still a process that has to be done manually. The flat file contains all the information that determines how the question needs to be displayed (I've created a column that identifies the specific type of question). Is there a way to have Tableau interpret the flat file automatically and create a new worksheet for each question that is auto populated with the appropriate view for that question type?
I've attached a sample of the flat file in excel and an example of what I would hope the final output would look in Tableau. (The data is fake data and I'm using Tableau Desktop 10.4)