Loading

Split Field With Multiple Punctuation And Duplicate Columns To Rows

Udgivelsesdato: Mar 18, 2026
Opgave

How to split the fields with punctuation and convert them to new roles automatically
Original data
User-added image
Expected Result
User-added image

Trin
1. Split the fields with multiple punctuations: create a calculation field with replace function and then split
REGEXP_REPLACE(
REPLACE(
REPLACE(
[company]
,"[","")
,"]","")
,'"',"")

2. Splitting fields into new rows is a known feature request
Possible workaround: convert columns to rows by creating pivot fields
 
Yderligere ressourcer

To voice your support for the inclusion of this feature in a future product release, add your vote to the following Idea: Text to Rows >> Tableau Prep
 

Vidensartikelnummer

001456694

Vedhæftede filer

Results.tflx

11 KB

Workaround.mp4

2187 KB

 
Indlæser
Salesforce Help | Article