nmccutcheon
Data Storage
Joined 3 years ago
User Profile
User Widgets
Contributions
Table Join
I'm having an issue joining two tables an suspect it's due to the integer value within the tables. In SQL, I'd join like this: SELECT top 1000 * FROM tblOrderRouteStops R WITH(NOLOCK) INNER JOIN tblOrderRouteStopsParcelAssigned PA WITH(NOLOCK) ON R.PKID = PA.ORSID INNER JOIN tblOrderRouteStopsParcel P WITH(NOLOCK) ON PA.ParcelID = P.PKID When attempting to join in Sisense the join values are not showing as optional. In tblorderroutestops, PKID is represented as an 8 digit integer and in tblorderroutestopsparcelassigned ORSID is represented as an 8 digit integer WITH TWO decimals. Is there a work around here?865Views0likes0Comments