Pentaho Kettle weird Left Join results
I am using kettle too make a left join between two tables who share common keys, however despite in some rare cases the join works as I intended, in most of them it returns NULL despite sharing the same key as in the cases where it works. Like in the example bellow.
EDIT: In one table I have ID_DOENTE and ID_TIPO_CONSULTA, while in other I have TIPO_CONSULTA and ID_TIPO_CONSULTA. I am merging the first table using left join with the 2nd using ID_TIPO_CONSULTA as the key. The result is the following
As you can see the in the rows with ID_DOENTE 40, the join works in a single case, but for all the other rows despite the situation being identical it leaves the values coming from the 2nd table as NULL.
Regarding "merge join" step:
Note: In this step rows are expected to be sorted on the specified key fields.
- fuzzy_join of two dataframes based on ZIP codes
- R dplyr conditional join with "join_by" not working
- How to merge two datasets based on different time interval conditions?
- count distinct values while left joining
- Why is LEFT INNER JOIN deprecated?
- How do you perform a left outer join using linq extension methods
- How to join two datasets based on the id, date and approximate time?
- SQL INSERT INTO with JOIN
- What Run time error in an SQL Query for join means
- How to JOIN M:M table the right way?
- Left Outer Join doesn't return all rows from my left table?
- many to many in left_join
- Left outer join from more tables with dates
- Order of keys in the LEFT JOIN condition
- SQL Server Left Join With 'Or' Operator
- SQL query left join with sum,group by and order by in MS Access
- PyPolars, conditional join on two columns
- sum case with left join
- How to add multiple LOOKUPVALUE columns in the table with filter on the another table efficiently (in Python)?
- Explain JOIN vs. LEFT JOIN and WHERE condition performance suggestion in more detail
- Remove duplicate rows from LEFT JOIN with SELF JOIN
- T-SQL: Single-Query Join with either one Table or another
- Select data from two records in same table in a single query using MYSQL and PHP
- Postgres returns [null] instead of [] for array_agg of join table
- Joining Dataframes with Many to Many Relationship in R
- Left join sum error: how to solve this error?
- MongoDB Join filter, input, as, if, eq _id exists
- Dapper - Map join query to DTO using 'splitOn'
- Is there a way to retain keys in Polars left join
- How to left join with multiple conditions in pandas?