KNOWLEDGE BASE

Change Multiple Field Names in Bulk in Tableau Prep Builder


Published: 28 Sep 2021
Last Modified Date: 27 Mar 2024

Question

How to change multiple field names in bulk.
For example, change the field names from the left to the right like the image below.
User-added image

 

 

Environment

  • Tableau Prep Builder 2021.2 and later

Answer

Option 1
Use [rename fields in bulk] function in Tableau Prep Builder 2021.2 and later.
Limitation: You could replace text, add prefix or suffix but it is difficult to change field names into totally different ones in bulk.

[Clean and Shape Data -- Rename fields in bulk]
Option 2
Use the Pivot function to replace the filed names. Please prepare a name-changing list for this option.
User-added image
The steps are as follows. Please check the attached flow file for details.
User-added image
 
Did this article resolve the issue?