Skip to Content
0

Data source join error

Dec 16, 2016 at 08:30 PM

55

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Christoforos Verras
Dec 22, 2016 at 01:19 PM
0

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

Show 1 Share
10 |10000 characters needed characters left 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...

0