2 Replies Latest reply on Nov 1, 2016 9:40 AM by Christina Morgan

    Blending Sharepoint data in Tableau

    Syam Tadikamalla

      Hi All,

       

      Using ODATA, I have extracted data from two Sharepoint links. One source have IDs / other information and other two data source have names for each id. As TAbleau does not support $expand, I have join the extract the data after pulling from Sharepoint.

       

      Extract 1

       

      AssignedIDIssueIDOffice
      21Washington
      26NY
      35CA
      31Washington
      46Boston

       

      Extract 2

       

      IDName
      1David
      2Harris
      3Sam
      4Mike
      5Steve
      6Ram

       

      I am looking for creating 'Calculated Fields' in Extract 1 similar to below table and AssignedName and IssueName are pulled from Extract2.

       

      AssignedIDAssignedNameIssueIDIssueNameOffice
      2Harris1DavidWashington
      2Harris6RamNY
      3Sam5SteveCA
      3Sam1DavidWashington
      3Sam4MikeBoston

       

      So that I can use AssignedName and IssueID as Drop-downs on dashboard in which AssignedName Dropdown will have two names - Harris & Sam and IssueName will have four names - David, Ram, Steve, Mike. Because if I use Drop-downs directly from Extract-2 then drop-downs will have all six names.