Error: The method append(Object) in the type StringBuilder is not applicable for the arguments ()

[EnriqueLDE]

Hello,

I'm using an Excel (all the data are String variables) trying to merge rows with replicated values. For example, if I have 5 rows with the word Monday i want Talend to merge this information in a single row setting the same text (I'm using tDenormalize for this). This is the job:

After executing job I get this error:

Code:

I would like to know why this error in the generated code appears. Thanks!

[akumar2301 · Accepted solution]

add a delimiter in tDenormalize. This should work.

[EnriqueLDE]

Thanks @uganesh, that was the problem! 2 questions:

-If my Excel has null cells, how do i delete the default "null" value I get in the output? 

-I read tDenormalize can change input order. Is there any component or way to order the data again like the original order?

Thanks again!

[akumar2301]

Looks like you are trying to remove duplicated from file. You could use tUniqRow also.
I assume , tUniqRow will maintain the order of input .

[EnriqueLDE]

Perfect, thanks @uganesh !