Relating tables :S

[José de María Santiago Arenas]

Hi!

I am relating an excel table with an Oracle table (mode: add columns) but the resulting table has a much higher number of rows than the source table (excel), why?

The result should be the same number of source rows but with more columns (the ones added from Oracle).

* When I make the connection between the tables, I do the column mach, and join settings = Left after join.

I have done this many times before but this time it does not work correctly, it must be something wrong configured.

1st table:

Result table:

 

THANKS!!

[José de María Santiago Arenas]

I already tried with "Inner join" but same problem :S

[Fredrik Rosell]

Hello,

One reason could be that there are multiple rows/values in Oracle that match a single row in your Excel data.

You wrote that you use "join settings = Left after join" ("left outer join" I assume), which could result in more rows than in the original data if there are multiple matches. If there are multiple matches - what result do you want? Using "Left single match join" would be one way ensure there is only a single match from the Oracle data.

 

[José de María Santiago Arenas]

It works!

Thank you Fredrik!

[Fredrik Rosell]

That's great to hear - thank you for confirming!