Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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?

 

 

Labels (1)
  • v7.x

7 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

hello shong,

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

 

should i replace the type one by one?

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

hello shong, 

 

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

 

can it be different, if i use sync coloumn?

 

 

Anonymous
Not applicable
Author

0683p000009M9mC.png0683p000009M9rB.png0683p000009M9rG.png0683p000009M9a7.png

Anonymous
Not applicable
Author

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
manodwhb
Champion II
Champion II

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