2 Replies Latest reply on Dec 22, 2016 12:38 AM by Sireesha J

    How to append two data with few common and few unique fields

    ankur batla

      I have two database in .tde file :

       

      File 1

      DateSiteSectionUVVisitPage viewsAAABBB

      CCC

      File 2

      DateUVVisitPage viewsXXXYYYZZZ

      Bold items are common among these two file

       

      I would like to have output like this :

       

      DateSiteSectionUVVisitPage viewsAAABBBCCCXXXYYYZZZ

      If any field doesn't have data against it it should write NULL

       

      I don't wanna do this merger outside the tableau environment (as i need automated procedure for this) .

       

      Looking for your response

       

      Thanks in advance