Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Column causing problems after appending two tables to get past relationship problem

Hello,

 

I had an the issue where I could not create a relationship because there were duplicates in two tables. After creating a new table without duplicates by appending the two tables my table still will not display the desired result.

These are all my relationships.

I would like to display "Message" from Device_Ping_Status but it just says I can't display the visual when I add it to the table along with CAR_ID and Status from Device_assigned_application and Device_Extended. I'm sorry if I wasn't able to articulate the problem properly but it was just a little hard to put into words for me.

 

Any help would be appreciated.

2 Replies

  • DouweMeer's avatar
    DouweMeer
    Icon for Impactful Individual rankImpactful Individual
    7 years ago

    Can you share some print screens to show what kind of errors you see?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Here is the error and my specific relationships. I want to make a table based off of this SQL Query: 

      SELECT [CAR_ID] AS car_id

      ,[DeviceName] AS device_name

      ,[Status] AS stat

      ,[Environment] AS environment

      ,[DR_TIER] as dr_tier

      ,[Message] as ping_response

      ,[PingFailedCount] as ping_failed_count

      ,[LastSuccessfulPing] as last_successful_ping

      FROM SCM.dbo.Device_Assigned_Applications A

      JOIN SCM.dbo.Device_Extended B ON A.DeviceID = B.DeviceID

      JOIN SCM.dbo.tbl_CAR C ON A.CAR_ID = C.CAR_PRIM_ID

      JOIN SCM.dbo.Devices D ON A.DeviceID = D.DeviceID

      JOIN SCM.dbo.Device_Ping_Status F ON A.DeviceID = F.DeviceID;