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


      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