Seleccionar una organización
How to Split a Field by a Specific Character and Add Results as New Rows
Fecha de publicación: Dec 22, 2025
Tarea
Transform input data containing a delimited string in a field (e.g., [Order Date]) into separate rows for each value. This method applies to any specific character or string, not limited to commas.
Example Transformation:
- Before: OrderID "b" with Order Date "2025/12/02, 2025/12/03"
- After: Two rows for OrderID "b" with "2025/12/02" and "2025/12/03" respectively.
Pasos
Follow these steps to split the field:
- Create a calculated field to extract the part to the left of the comma (e.g., retrieve "2025/12/02").
TRIM( SPLIT( [Order Date], ",", 1 ) ) - Create a calculated field to extract the part to the right of the comma (e.g., retrieve "2025/12/03").
TRIM( RIGHT([Order Date], if(FINDNTH([Order Date],",", 1) > 0) then LEN([Order Date]) - FINDNTH([Order Date],",", 1) - LEN(",") + 1 else 0 end) ) - Use the Pivot function to merge the columns created in steps 1 and 2.
- Retain only the merged column and the "OrderID" field.
Recursos adicionales
For more information, see the attached sample flow "How_To_Split_And_Add_As_New_Rows.tflx".
Número del artículo de conocimiento
003962197
¿Resolvió este artículo su problema?
¡Háganos saber cómo podemos mejorar!
