知識庫

Change Multiple Field Names in Bulk in Tableau Prep Builder


發佈時間 : 28 Sep 2021
上次修改日期 : 27 Mar 2024

問題

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
 
這篇文章是否解決了問題?