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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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.