topic Re: Error in tSampleRow ("The method split(String) is invalid...") in Talend Studio

Error in tSampleRow ("The method split(String) is invalid...")

Anonymous — Thu, 22 Oct 2015 22:00:04 GMT

In my job, I'm pulling files from a database, and wanting to divide full number of rows by four. I output each quarter of rows to a separate file. Here's my job:

In order to do this, I'm using a tJavaFlex component, which increments a variable by 1 for every value in ColumnA that isn't null, and then places that value in a global variable using globalMap.put(). Here's the code:

What I'm trying to do is call this variable in a tSampleRow component, with the following code:

When I try to run the job, I get the following error:

Am I attempting to do something impossible? If not, what is my mistake? I'm not sure what value in my job has a type of Object.

Thanks in advance for the help.

Re: Error in tSampleRow ("The method split(String) is invalid...")

Anonymous — Fri, 23 Oct 2015 08:48:13 GMT

Hello,
I am not sure but the error talks about a type "Object", so maybe when you call your globalMap you have to "prefix" it with the return type of the get like that :

(String) globalMap.get("HFScount")

I hope this answer can help you.

Re: Error in tSampleRow ("The method split(String) is invalid...")

Anonymous — Fri, 23 Oct 2015 19:40:35 GMT

tdz,
Thank you for the suggestion. When I make the change you advised, I get the following error message: "Type mismatch: cannot convert from String to String[]".

Re: Error in tSampleRow ("The method split(String) is invalid...")

Anonymous — Mon, 26 Oct 2015 08:39:42 GMT

Oups, sorry for the mistake, I think you have to cast the result of the globalMap in Integer (and not in String) like that :

(Integer) globalMap.get("HFScount")

Re: Error in tSampleRow ("The method split(String) is invalid...")

Anonymous — Tue, 27 Oct 2015 18:34:57 GMT

tdz,
This results in the following error message: "The method split(String) is undefined for the type Integer".

Re: Error in tSampleRow ("The method split(String) is invalid...")

Anonymous — Fri, 30 Oct 2015 10:43:15 GMT

sdvorak wrote:
tdz,
Thank you for the suggestion. When I make the change you advised, I get the following error message: "Type mismatch: cannot convert from String to String[]".

Hello sdvorak,

Could you please show us how and where you use the split method which is mentioned in your first post ?
Thank you.