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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Help with "Type Mismatch" errors

I'm new to Talend and needing help getting past the following "Type Mismatch" errors:
Warning! Some errors exist in job. Would you like to continue?
Type mismatch: cannot convert from Float to String
Type mismatch: cannot convert from Float to String
Type mismatch: cannot convert from Integer to Double
Type mismatch: cannot convert from String to Date
Type mismatch: cannot convert from String to Date
Type mismatch: cannot convert from Integer to Double
Type mismatch: cannot convert from String to Date

Here is my tMap:

Labels (2)
6 Replies
_AnonymousUser
Specialist III
Specialist III
Author

How do I login in order to post an image of my tMap?
- I created an account
- I click on login, but I'm already logged in? It shows my account info, but forum page does not show that I'm logged in?
_AnonymousUser
Specialist III
Specialist III
Author

Keeps saying: You are not logged in.
_AnonymousUser
Specialist III
Specialist III
Author

Here is my tMap:
_AnonymousUser
Specialist III
Specialist III
Author

Ok, I was able to resolve all of the errors by going into the "input" side of the tMap columns and match their "data Type" & "Date Pattern" columns to the "output" side.
Now that the data is uploading into Salesforce, I have one last issue:
[list=1]
  • Company Name is being loaded into Salesforce as a long ID? (for example: "Keepes Funeral Home" comes in as "a0W0P00000C1f5w"?)

  • In Salesforce, this field is the "Name" field (Text(80) 

  • _AnonymousUser
    Specialist III
    Specialist III
    Author

    Fixed my issue.
    had the wrong field mapped in Talend.

    [list=*]
  • I added in the Name field on the tMap (on the Salesforce side)

  • Then mapped it to the ActDes field (on the MySQL side)


  • The MBS Name field is now updating correctly.
    _AnonymousUser
    Specialist III
    Specialist III
    Author

    Now ready to try and schedule this job in Talend.