0 Replies Latest reply on Oct 11, 2018 4:11 AM by Juha Koivuneva

    Join headers from file 1 to data from file 2 in Tableau Prep

    Juha Koivuneva
    Juha Koivuneva Oct 11, 2018 4:11 AM

      I have 2 files, first of them is a solid one containing 1 row with 64 columns, those are the headers.

      Second file is updated regularly, but unfortunately missing column headers. Those are in 1st file that I want to combine with 2nd file.

       

      File 1:

      Header 1 Header 2Header 3

       

      File 2:

      Data1Data2Data3
      Data4Data5Data6
      Data7Data8Data9

       

      Wanted result:

      Header 1Header 2Header 3
      Data1Data2Data3
      Data4Data5Data6
      Data7Data8Data9

       

      I have tried all JOIN functions without success and UNION is not working either.

      Any ideas?