Two versions of Talend giving different results

[Anonymous]

I have a Talend job that runs fine on my machine but gives incorrect results on a colleague's computer. I have Talend 6.1 and Java 8 (update 181). The other person has Talend 7.1.1 and Java 8 (update 191).

The difference is in a tMap that joins 5 data streams. As I say, it all works correctly for me. But the other person's set up gives a final result that (probably) implies one of the joins does not work.

Can you suggest what's changed in Talend that might affect this?

Although it is rather hard to pull it apart to isolate which join is problematic, the most likely candidate is this one:

The code in that join is this:

(Church.Name == null || Church.Name.length() == 0 
|| Church.Denomination__c == null || Church.Denomination__c.length() == 0)
    ? ""
: Church.Denomination__c.toUpperCase().contains("ANGLICAN")
    ? "Anglican"
: Church.Denomination__c.toUpperCase().contains("APOSTOLIC")
    ? "Apostolic"
: Church.Denomination__c.toUpperCase().contains("Catholic")
    ? "Catholic"
: Church.Denomination__c.toUpperCase().contains("CHURCHES OF CHRIST")
    ? "Church of Christ"
: Church.Denomination__c.toUpperCase().contains("CHURCH OF CHRIST")
    ? "Church of Christ"
: Church.Denomination__c.toUpperCase().contains("UNITING")
    ? "Uniting Church of Australia"
: Church.Denomination__c 

[Anonymous]

Hello,

We need more information to address your issue.

Could you please give us more information or background about "one of the joins does not work."? Are you working collaboratively on a project?

Best regards

Sabrina

[Anonymous]

THANK YOU FOR YOUR RESPONSE.

What I meant by "one of the joins does not work." is that same job was imported from version 6.1 to 7.1 but at the point in the job we got 4 tables and 5 joins, in version 7.1 one of the join returns null. We want to continue running the job in version 7.1 going forward.

See attached

Join-Capture.PNG

[Anonymous]

In addition the join and code above gives null result in version 7.1 but work ok in version 6.1.

Thank you

[Anonymous · Accepted solution]

Hi,

    Could you please print the data before tmap and see whether the same data is available for match process in both versions? I have doubt whether the data (especially the lookup) is having same data for both versions and that could be the problem. Also hope you don't have any trailing or leading space in data for one of the versions.

Warm Regards,

Nikhil Thampi

[Anonymous]

Thanks All,

The issue is resolved. A hidden schema difference in both cause the problem but useful troubleshooting suggested was  very useful.

Thanks

[Anonymous]

Perfect!

Happy to know that you have identified and resolved the issue 🙂

It is always recommended to print your results and verify them in console as it is the most easy and visual way to identify the problems.

Happy programming in Talend 🙂

Warm Regards,

Nikhil Thampi