10 Replies Latest reply on Jul 27, 2016 7:02 AM by Michael Hesser

    merging field data from 3 seperate data sources

    Tony Ball

      Hi All,

       

      I just had a quick question regarding if Tableau has the ability to merge details from 3 data sources?

       

      I'll explain quickly what I am trying to achieve. I have 3 data sources in one workbook. 1 source is an excel sheet and 2 are MS SQL tables (the databases are separate so can't join).

       

      In each data source is a column that references Server Name. (All the columns have similar names)

       

      I wanted to know if it possible to merge these 3 columns in some way to make one dimension in Tableau that contains the Server Name data from the 3 columns?

       

      I'm restricted due to access and security from doing this kind of merge at the data level and wondered if Tableau itself had any functionality to do this with blended data?