Hi! I have a table named S800 which has a column named MATERIAL. I'm trying to use this columns as a key from another table (MATERIAL_2020) which has the same column. I tried both left join (S800 being the left) and a lookup, but both produced the same result: there are some MATERIAL id's that are not matching. I will post some screenshots to clarify.. Both columns have the same data type.
In the screenshot below, I did a select in bigquery to see if there was a value assossiated with the MATERIAL and GRP_MERC.
After I did the lookup/left join, GRP_MERC was not found by trifacta.
What can be the cause of this?