Split Field With Multiple Punctuation And Duplicate Columns To Rows
Published: 22 Jun 2020 Last Modified Date: 26 Oct 2022
Question
How to split the fields with punctuation and convert them to new roles automatically Original data Expected Result
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
Thank you for providing your feedback on the effectiveness of the article.