BASE DE DADOS DE CONHECIMENTO

Change Multiple Field Names in Bulk in Tableau Prep Builder


Publicado: 28 Sep 2021
Data da última modificação: 27 Mar 2024

Pergunta

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

 

 

Ambiente

  • Tableau Prep Builder 2021.2 and later

Resposta

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
 
Este artigo resolveu o problema?