How to combine two excel files with same fields but different data (different years)?
- 1 Answers
- 480 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What type of data limitations does tableau public have?
How do you create ext4 file system?
What is TDE file in Tableau?
What are the different filters in tableau?
Make a case for the mixing of tableau with r?
Can parameters have the dropdown list?
will Tableau perform with vast datasets?
What is aggregation of data in tableau?
What number ways in which we tend to use parameters in Tableau?
What are groups?
What is mean by forecasting with reference in tableau?
Think that I am using tableau desktop & have a live connection to cloudera hadoop data. I need to press f5 to refresh the visualization. Is there anyway to automatically refresh visualization every ‘x’ seconds instead of pressing f5?
QlikView 
