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, Jones32141Alex, Bulman312312Russel, Terry & John, Stockton
Table 2:
TractIDOwner123312Jim, Jones123312Maria, Jones32141Alex, Bulman312312Russel, Terry312312John StocktonAn 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
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