Left join doesn't work

[KirstenKa]

This is what I would like to establish with my joins

I have 5 datasources and I would like to join all together. I have 1 main datasource (datasource 1) from which I would like to do a left join to all datasource. My code looks like this but it doesn’t return any data, though it doesn’t give an error when the script, and it creates 1 tables which contains all values from the different datasources . My script looks like this, what goes wrong. I already checked if I match with exactly the same columns but that is the case

Main datasource to which I join

Joins to main datasource

[cristianj23a · Accepted solution]

When you do a join, the data in your relationship fields (in this case "ItemColor_GlobalId") must be exactly the same.

In the images you send, they are not.
For example:

C8FT:
your data ends in "Global ID"

but in the other table (C8App) where you are doing Left Join, it ends in "Color Code", for them to match it must end in "Global ID".

Regarts.

[KirstenKa]

Thanks that works @cristianj23a  however from 1 datasource to the other I really need global_id else I have missing data, and in other datafiles I don't have global_id and might need to join there on another unique third value, how can I deal with this/resolve this?

[cristianj23a]

Play with relationships, I have a query.

For example, in C8FT, I see concatenated data, . Are those 3 data the concatenation of 3 fields to obtain %ItemColor_GlobalId?

If you have test data, send it to me and I'll figure it out for you.

[KirstenKa]

@cristianj23a I have uploaded the files and the script. 

Are those 3 data the concatenation of 3 fields to obtain %ItemColor_GlobalId? -> yes

From C8 to Infa it is joined on Trading code, Color Code and Global ID

From C8 to other datafiles its is Trading code and Color Code -> different value names in the different files  

[KirstenKa]

Here is the load script

[KirstenKa]

@cristianj23a  eventually the problem was that I had 2 almost similar files. It was solved by using concatenate instead of left join

[cristianj23a]

Hello KirstenKa, I'm glad that it has been solved, sorry for not responding on time, I was traveling because in my country we are on national holidays.

Regarts.

[KirstenKa]

No problem @cristianj23a , thanks for thinking with me you brought me in the right direction. It is appreciated