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

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

EnriqueLDE — Wed, 23 Jan 2019 11:59:11 GMT

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!

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

akumar2301 — Wed, 23 Jan 2019 12:49:41 GMT

add a delimiter in tDenormalize. This should work.

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

EnriqueLDE — Wed, 23 Jan 2019 13:36:37 GMT

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!

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

akumar2301 — Wed, 23 Jan 2019 14:06:27 GMT

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

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

EnriqueLDE — Wed, 23 Jan 2019 15:48:53 GMT

Perfect, thanks @uganesh !