Wednesday, 15 May 2013

Extract City Name in Talend -


I have a sample data where I want to put the city on a different column. Cities can be defined after commas, I can do it with talent, which component should I use?

Here the sample data is my input on the left and should be the correct right output.

Enter image details here

< Div class = "post-text" itemprop = "text">

You can use the split function in TMP. Use the code below in the city column, just replace the dwetl address field with your actual column name.

 ! Relational. ISNUL (row7.dwetl_Address)? Row7.dwetl_Address.split (",") [1]: "Default City"  

No comments:

Post a Comment