Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
4 views
in BI by (17.6k points)

I'm new to Tableau and now have a CSV file without column names. All data are stored in this CSV file. There is another CSV file that contains all column names. I am trying to add these names to the unnamed data file. Is there a way to do it? I know I could open the CSV file and copy the name manually, but I wish I could operate it in the Tableau.

Thanks.

1 Answer

0 votes
by (47.2k points)
  • You have to connect to a CSV file that does not have a header row, and then name the fields yourself in Tableau when editing the data connection.

  • Click on the Settings (gear-shaped) icon on the right side of the table in the data source pane.

 enter image description here

  • Now, specify that there is no header row and that Tableau should generate names for the fields.

 enter image description here

  • Then rename the fields from their generated names like F2, F2, etc to something meaningful, by clicking on the little black triangle icon next to the generated field names and choosing rename.

Related questions

0 votes
1 answer
asked Jul 24, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
asked Jul 22, 2019 in BI by Vaibhav Ameta (17.6k points)
+1 vote
1 answer
asked Oct 31, 2019 in Data Science by chandra (29.3k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...