Skip to main content
Solved

split a row into multiple rows by a field with delimited values

  • October 20, 2016
  • 2 replies
  • 294 views

Forum|alt.badge.img

Hi, my table has a Owner field with multiple values delimited by either ; or &. Please see below table 1 for an example.. How to split the first and the third rows into multiple rows so the result like the table2?

Table 1:

TractIDOwner123312Jim, Jones; Maria, Jones

 

32141Alex, Bulman312312Russel, Terry & John, Stockton

Table 2:

TractIDOwner123312Jim, Jones123312Maria, Jones32141Alex, Bulman312312Russel, Terry312312John Stockton

Best answer by ebygomm

An AttributeSplitter followed by a list exploder will do this. If you want to split by multiple attributes it's probably best to replace the ampersand with a semi colon using a string replacer prior to using the attribute splitter

View original
Did this help you find an answer to your question?

2 replies

ebygomm
Influencer
Forum|alt.badge.img+32
  • Influencer
  • Best Answer
  • October 20, 2016

An AttributeSplitter followed by a list exploder will do this. If you want to split by multiple attributes it's probably best to replace the ampersand with a semi colon using a string replacer prior to using the attribute splitter


Forum|alt.badge.img
  • Author
  • October 20, 2016
ebygomm wrote:

An AttributeSplitter followed by a list exploder will do this. If you want to split by multiple attributes it's probably best to replace the ampersand with a semi colon using a string replacer prior to using the attribute splitter

Thanks for the diagram. Works perfect!

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings