KNOWLEDGE BASE

Change Multiple Field Names in Bulk in Tableau Prep Builder


Published: 28 Sep 2021
Last Modified Date: 26 Oct 2021

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?