Skip to Content

Data source join error

Hi All,

I am trying to create a new data source using 3 native tables:

1. Opportunity Involved Parties

2. Employee Master Data

3. User Current Status

I have created a left join using #1 and #2 above, joining 1.Party to 2.Employee

Now i want to join in table #3 to #2 on 2.User ID = 3.User

But i keep getting the error shown here.

How can i join this third table to the second table?

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 22, 2016 at 01:19 PM

    Hi,

    It looks like you are trying to join a numeric field (ID) with a text (user).
    You should try to join only related type fields with each other.

    Maybe a user ID field on the User Current Status table.

    .CV

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks when we changed the join type to Inner Join, the join pair "worked" - actually on the yellow warning came up, but i was able to click Save and Close..weird. When i previewed the data source it actually worked as expected. So it didn't prevent me from saving that data source with that one last remaining warning...