Search code examples
talend

Talend split fields from one to double

I have mysql table with text field "email", which can contain "[email protected]" and "[email protected];[email protected];[email protected]".

| Name    | Email                                                  |
| user    | [email protected]                                       |
| user1   | [email protected];[email protected];[email protected]  |

How can i do output with Talend such this:

| Name    | Email              |
| user    | [email protected]   |
| user1   | [email protected]  |
| user1   | [email protected]  |
| user1   | [email protected]
Solution

  • The tNormalize component does exactly this. You can provide a character for separation, in your case ; and get rows as result afterwards.

    EDIT

    AxelH pointed out that it is possible as well to use a String for separation, this is not a Character.