KNOWLEDGE BASE

Split Field With Multiple Punctuation And Duplicate Columns To Rows


Published: 22 Jun 2020
Last Modified Date: 23 Jun 2020

Question

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

Environment

  • Tableau Prep Builder 2020.2.2
  • Windows 
  • Excel

Answer

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
 

Additional Information

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