Change Multiple Field Names in Bulk in Tableau Prep Builder

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


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




  • Tableau Prep Builder 2021.2 and later


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?