topic Error in the component's properties:Type mismatch: cannot convert from Integer to String in tUnite in Talend Studio

Error in the component's properties:Type mismatch: cannot convert from Integer to String in tUnite

Anonymous — Mon, 23 Mar 2020 09:20:17 GMT

i have problem with tUnite

i have data with string type but in tUnite error like this "Error in the component's properties:Type mismatch: cannot convert from Integer to String"

what should i do?

Re: Error in the component's properties:Type mismatch: cannot convert from Integer to String in tUnite

Anonymous — Tue, 24 Mar 2020 03:47:46 GMT

Hi
Check the schema of each component that linked to tUnite, make sure all of them has the same schema as output's schema.

Regards
Shong

Re: Error in the component's properties:Type mismatch: cannot convert from Integer to String in tUnite

Anonymous — Tue, 24 Mar 2020 07:20:20 GMT

hello shong,

i get data from my database, and the type of data default from database.

should i replace the type one by one?

Re: Error in the component's properties:Type mismatch: cannot convert from Integer to String in tUnite

Anonymous — Tue, 24 Mar 2020 07:43:03 GMT

Hi
It's OK to use the default type, your problem is the data type of input schema is different from the data type of output schema, open the schema of tUnite component, compare the schemas and you will see the differences.

Regards
Shong

Re: Error in the component's properties:Type mismatch: cannot convert from Integer to String in tUnite

Anonymous — Tue, 24 Mar 2020 07:50:21 GMT

hello shong,

i using sync coloumn in tUnite and i compare the input and output

can it be different, if i use sync coloumn?

Re: Error in the component's properties:Type mismatch: cannot convert from Integer to String in tUnite

Anonymous — Tue, 24 Mar 2020 07:54:25 GMT

Re: Error in the component's properties:Type mismatch: cannot convert from Integer to String in tUnite

Anonymous — Wed, 25 Mar 2020 03:40:57 GMT

Hi
tUnite merges data from various sources, based on the same schema.. eg:
input1:
id;name
1;shong
2;elise

input2:
id;name
3;ross

After tUnite, it outputs:
id;name
1;shong
2;elise
3;ross

If you want to join two data sources, you should use tMap.

Regards
Shong

Re: Error in the component's properties:Type mismatch: cannot convert from Integer to String in tUnite

manodwhb — Wed, 25 Mar 2020 07:23:31 GMT

You need to join with tMap and join on I'd column.