Solved

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

  • 20 October 2016
  • 2 replies
  • 54 views

Badge

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

icon

Best answer by ebygomm 20 October 2016, 19:05

View original

2 replies

Badge +10

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

Badge

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!

Reply