tMap Problem with NULL values on identic JOBS

[Anonymous]

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

[TRF]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

Convert them to Date typed values!

[Anonymous]

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.

[Anonymous · Accepted solution]

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 !