I am working on designing an Alteryx workflow that would take input file (CS1 data.xlsx) and convert it into an input for tableau to create dashboard out of the data.
The sample output (OutPut_data.xlsx) is attached for reference. However, the cleansed output should be in the form of tableau data source (.tds).
Question:
A survey on 500 respondents and asked six questions in the survey (Details
in “Data dictionary” appendix on page 2). The company needs to identify the % of respondents
who answered 4 or 5 in each “Domain area” (Question 6).
Solved! Go to Solution.
Hi @vinamra101 ,
Here is a workflow for the task
Output:
Workflow:
Sorry i was not able to get the difference between your files but this is what you are looking for
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Hi @vinamra101 , is this what you are looking for to create a replica of the output file that you mentioned and save it as .tde?
If this is what you are looking for kindly mark this post as solution.
Thanks.
Hi @vinamra101 ,
Here is a workflow for the task.
Output: matches the expected
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
can you explain the workflow ?
i am puzzled in understanding this
Hi @rahulm97
Apologies for the late response.
Here is a workflow which has a detailed explanation commented on each tool/step.
Take a look into the workflow. Feel free to drop a reply if you need any more help.
Hope this helps 🙂