Joining tables

[LaurensH]

Hi Everyone,

I am having some trouble with my script. What I want to do is join the table I have already (investments) with another table (collaborations). They should join on Startup_Name. Now the field "Cluster" exists in both tables and should become one field.

- When I use the script in 1), I get output 2). 

- If I deactivate the second yellow line in 1), I get output 3). This is what I need but now i obviously lose the data that I would normally get with the second yellow line. In this example this does not have consequences but it does for other startups.

My Question:

How can I make my script as such that I can join both of the tables and I get the output that I want?

Thanks in advance!

1)

2)

3) 

[LaurensH]

Personally I think the problem is in the fact that the Join has two identical field names as the table I want to join it with. 

Still, I cannot change the name of one of them since the whole point is that they join on Startup_Name and Cluster gets combined. How can I do this? Can I say something like JOIN ON?

Thanks!