topic Re: tMap Problem with NULL values on identic JOBS in Talend Studio

tMap Problem with NULL values on identic JOBS

Anonymous — Sat, 16 Nov 2024 04:31:58 GMT

Hi everyone, I am completely new and am experiencing some problems joining 2 tables;

-Bank Transactions

-Currency rate

(only matching column being the Date)

When I create a job using those tables as delimited files the job runs successful

(Image 1 - a joined list is displayed showing NULL values only where there are no transactions on the specific date)

If I create an identical job with one source delimited and other MySQL I end up with all lookup values displayed as NULL (Image 2)

Join is identical in both jobs (Image 3)

JOB 1 delimited filesJOB 2 delimited file and MySQLJOIN

Any advice is welcome

Re: tMap Problem with NULL values on identic JOBS

TRF — Mon, 30 Sep 2019 10:00:45 GMT

I'm afraid both "datum" fields used for the join are not expressed with the same format

Re: tMap Problem with NULL values on identic JOBS

Anonymous — Mon, 30 Sep 2019 10:12:36 GMT

Hi, the format of the Date typed fields are mostly irrelevant because this pattern is only used when converting the Date typed field into text format of read it from text format. As long as you deal with the Date typed value you do not need the pattern.

You have to check if you have your date pattern fits to the text values in your input file.

And please check the join condition. You have chosen "Unique match" - means if the lookup has more than one records with the same date it will not match.

Re: tMap Problem with NULL values on identic JOBS

Anonymous — Mon, 30 Sep 2019 10:12:44 GMT

So I should have both columns converted to datetime for instance ?

Re: tMap Problem with NULL values on identic JOBS

Anonymous — Mon, 30 Sep 2019 10:13:43 GMT

Convert them to Date typed values!

Re: tMap Problem with NULL values on identic JOBS

Anonymous — Mon, 30 Sep 2019 10:23:46 GMT

Ah I see matching all rows returned ALL matches for all dates and duplicate dates and all currencies.

I believe that actually I had used the Currency .csv in Jupyter Notebook and changed Datum column to datetime.. I will attempt another join with the original file.

Re: tMap Problem with NULL values on identic JOBS

Anonymous — Mon, 30 Sep 2019 13:38:37 GMT

I have managed to solve my issue.

Eventually I had changed schemas from both tables from repository to built-in

and changed date columns types to string !

Together with the all matching rows outer join results are now showing all trnsactions linked with both chosen currencies !

Thank You for the helpful hints !