topic Re: How to normalize a List to single String(see Example) in Talend Studio

How to normalize a List to single String(see Example)

Anonymous — Wed, 05 Sep 2012 08:41:44 GMT

Example:
I have a schema with id(String) and letters(List), and want to normalize this into key/letter.
From:
Row number id(String) letters(List)
1 k1
2 k2
to:

Row number id(String) letters(List)
1 k1 a
2 k1 b
3 k1 d
4 k2 b
5 k2 d
6 k2 g
Any component that do this ?
Audun

Re: How to normalize a List to single String(see Example)

Anonymous — Wed, 05 Sep 2012 09:31:40 GMT

Hi,
You can use tNormalize component for this job.
--
Regards,
Vinod

Re: How to normalize a List to single String(see Example)

Anonymous — Wed, 05 Sep 2012 10:42:11 GMT

Hi,
You can use tNormalize component for this job.
--
Regards,
Vinod

Can´t, tNormalize works on String not List.
regards
Audun

Re: How to normalize a List to single String(see Example)

Anonymous — Wed, 05 Sep 2012 11:30:25 GMT

Before applying tNormalize on the field you can convert the data type using tConvertType or by using toString() in tJavaRow .

Re: How to normalize a List to single String(see Example)

Anonymous — Wed, 05 Sep 2012 11:46:12 GMT

Hi,
You can use below mentioned graph and code as sample.
Job Map
-----------
tFileInputDelimited --> tJavaRow --> tNormalize --> tLogRow
tFileInputDelimited Input
-------------------------
id;letters
k1;a,b,c
k2;d,e,f
tJavaRow code
--------------------
output_row.id = input_row.id;
output_row.letters = input_row.letters.toString().replace("", "");
Hope that helps.
--
Regards,
Vinod

Re: How to normalize a List to single String(see Example)

Anonymous — Wed, 05 Sep 2012 13:45:24 GMT

Hi,
You can use below mentioned graph and code as sample.
Job Map
-----------
tFileInputDelimited --> tJavaRow --> tNormalize --> tLogRow
tFileInputDelimited Input
-------------------------
id;letters
k1;a,b,c
k2;d,e,f
tJavaRow code
--------------------
output_row.id = input_row.id;
output_row.letters = input_row.letters.toString().replace("", "");
Hope that helps.
--
Regards,
Vinod

Why convert a List to String before creating a Array ? It will create bigger memory footprint. tNormalize should support List normalize.

Re: How to normalize a List to single String(see Example)

janhess — Wed, 05 Sep 2012 13:48:11 GMT

Why not define letters as a string in your schema.