How to combine two excel files with same fields but different data (different years)?
- 1 Answers
- 481 Views
- I also Faced
- E-Mail Answers
Answer Posted / Asha Sharma
To combine two Excel files with the same fields but different data, you can follow these steps:
1. Open both files in Tableau: Load each file as a separate data source in Tableau.
2. Match the fields: Make sure that the common fields have been recognized by Tableau and match them if necessary.
3. Create a union: In the data pane, right-click on one of the tables and select Union.
4. Combine the tables: Select the second table to be combined and click Ok.
5. Fill missing years: Once the tables are combined, you can use Tableau's date functions or calculations to fill any missing years with appropriate values.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can you display the top five and last five sales in the same view?
define the term filter actions
How to automate reports?
Explain one difference between tableau and other traditional bi tools
list out three tableau limitation
Make a case for the options of tableau eight.3?
What is tableau desktop?
Where can you use global filters?
However is tableau thus quick once operating with databases?
