What would be the best way to merge this data for use in tableau

[rmartori]

So hey if you also use a lot of tableau any advice in that regard would be great. 

There are 9 survey questions that they want a graphical representation of in Tableau they want it to look like this earlier example I made using a more rough excel file.

They gave me a new excel file that summarizes everything a bit more Multiple sheets that are mostly the same except for how many potential answers there are.
They all follow roughly the same format below.

Summary	Count	Percentage
CoStar	5	0.263158
Don’t Know/ None	5	0.263158
IBM Tririga	2	0.105263
Lease Accelerator	3	0.157895
Others	4	0.210526

again the only difference is the amount of answers some have 5 like above some have 3 some have 2 etc.

The only acception to the this is the first and second question

Question 1

SUMMARY BY SYSTEM	Count	Percentage	Tier
BlackLine	1	0.052632
Epicor	1	0.052632	Tier 3
Microsoft Dynamics	3	0.052632	Tier 2
Oracle EBS	9	0.052632	Tier 1
Oracle JD Edwards	1	0.052632
Oracle NetSuite	3	0.052632	Tier 2
Oracle Peoplesoft	3	0.052632	Tier 2
QuickBooks	2	0.052632
SAP (ECC)	1	0.052632	Tier 1
SAP (ERP Central Component)	3	0.052632
SAP (S4 Hana)	1	0.052632	Tier 1
Sage Intacct	2	0.052632	Tier 3
Survey doesn't let me select more than 1, I have seen SAP ECC, NetSuite and Sage Intacct pretty frequently in TMT Sector	1	0.052632	Tier 3
Taranga	1	0.052632
Workday	5	0.052632	Tier 3
Zuora RevPro	1	0.052632

Question 2

System	Tier	Involvement	Count
BlackLine		Operated the system at one of my previous jobs	1
Epicor	Tier 3	Extracted data from the client’s system while working on one of the projects, Limited to occasional discussion or desktop trainings	1
Microsoft Dynamics	Tier 2	Assisted/ advised the client on system implications related to my project	1
Microsoft Dynamics	Tier 2	Limited to occasional discussion or desktop trainings	2
None / I have already listed them all	N/A	Extracted data from the client’s system while working on one of the projects	1
None / I have already listed them all	N/A	None / I have already listed them all	16
None / I have already listed them all	N/A	Supported the client in a system implementation engagement, Extracted data from the client’s system while working on a project	1
Oracle EBS	Tier 1	Extracted data from the client’s system while working on a project	1
Oracle EBS	Tier 1	Extracted data from the client’s system while working on a project, Assisted/ advised the client on system implications related to my project	1
Oracle EBS	Tier 1	Extracted data from the client’s system while working on a project, Limited to occasional discussion or desktop trainings	1
Oracle EBS	Tier 1	Extracted data from the client’s system while working on one of the projects	1
Oracle EBS	Tier 1	Limited to occasional discussion or desktop trainings	1
Oracle EBS	Tier 1	None / I have already listed them all	1
Oracle EBS	Tier 1	Operated the system at one of my previous jobs, Extracted data from the client’s system while working on a project	1
Oracle EBS	Tier 1	Supported the client in a system implementation engagement	2
Oracle JD Edwards		Assisted/ advised the client on system implications related to my project	1
Oracle NetSuite	Tier 2	Limited to occasional discussion or desktop trainings	2
Oracle NetSuite	Tier 2	Supported the client in a system implementation engagement, Extracted data from the client’s system while working on a project, Assisted/ advised the client on system implications related to my project	1
Oracle Peoplesoft	Tier 2	Extracted data from the client’s system while working on one of the projects, Limited to occasional discussion or desktop trainings	1
Oracle Peoplesoft	Tier 2	Limited to occasional discussion or desktop trainings	1
Oracle Peoplesoft	Tier 2	Operated the system at one of my previous jobs	1
QuickBooks		Extracted data from the client’s system while working on one of the projects	1
QuickBooks		Limited to occasional discussion or desktop trainings	1
SAP (ECC)	Tier 1	Assisted/ advised the client on system implications related to my project	1
SAP (ERP Central Component)	Extracted data from the client’s system while working on a project	1
SAP (ERP Central Component)	Extracted data from the client’s system while working on one of the projects, Assisted/ advised the client on system implications related to my project	1
SAP (ERP Central Component)	Limited to occasional discussion or desktop trainings	1
SAP (S4 Hana)	Tier 1	Extracted data from the client’s system while working on a project, Assisted/ advised the client on system implications related to my project	1
Sage Intacct	Tier 3	Supported the client in a system implementation engagement	2
Survey doesn't let me select more than 1, I have seen SAP ECC, NetSuite and Sage Intacct pretty frequently in TMT Sector	Tier 3	Supported the client in a system implementation engagement	1
Taranga		Supported the client in a system implementation engagement, Extracted data from the client’s system while working on one of the projects, Assisted/ advised the client on system implications related to my project	1
Workday	Tier 3	Extracted data from the client’s system while working on a project	1
Workday	Tier 3	Extracted data from the client’s system while working on one of the projects	2
Workday	Tier 3	Limited to occasional discussion or desktop trainings	1
Workday	Tier 3	Operated the system at one of my previous jobs, Extracted data from the client’s system while working on one of the projects	1
Zuora RevPro		Operated the system at one of my previous jobs	1

So I am not sure what the best option would be to merge all of these together to make it easier for Tableau to use.

[MinaGO3]

I might need a bit more context to better help you but let me attempt to provide some help with a few assumptions.

1. With multiple files of the same structure you are going to want to use the union tool to combine them together. You may just want to put a select after every file has been input and before the union to ensure the column headers are the same. If column names are not exactly identical then they will not automatically stack on top of each other without further configuration of the union tool.

2. Add a formula tool with the logic that creates your RevPro, Other, Don't know/None category/field if needed. If instead you are now using system or system + tier, I would just make sure to instead use the formula tool to clean these up if needed.

I would put this data into Tableau at this stage without any aggregation in Alteryx. Tableau has the ability to aggregate and you limit yourself and your analysis if you do this in Alteryx.

Let me know if I have understood your problem correctly, if not are you able to attach the rudimentary excel creating the first Tableau chart as it may help me better understand the problem?