Data Manipulation & cleaning in Excel

[vinamra101]

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).

[atcodedog05]

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 😀👍

[vinamra101]

@atcodedog05

Thanks for the answer. 

The desired output(OutPut_data.xlsx) is attached here. 

All the columns remain intact just that we filter in values (4,5) for the columns M till AC.

[grazitti_sapna · Accepted solution]

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.

[atcodedog05 · Accepted solution]

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 😀👍

[atcodedog05]

Happy to help 🙂 @vinamra101 

Cheers and happy analyzing 😀

[rahulm97]

can you explain the workflow ? 

i am puzzled in understanding this

[atcodedog05]

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 🙂