9 Replies Latest reply on Sep 27, 2018 5:56 AM by Michael Gillespie

    Using JOIN in tableau prep

    Neel Patel

      Hello All,

       

      I NEED HELP WITH adding JOIN IN tableau prep

       

      I am trying to Join two .csv files using tableau prep.

      I am using an inner Join to combine two files based on a column that are similar in both files.

       

      According to my knowledge this is how Inner JOIN works:
      File A has 4 rows and 4 columns and File B has 3 rows and 3 columns.
      File A :
      1
      2
      3
      4
      A
      xx
      yy
      zz
      B
      tt
      hh
      kk
      C
      hh
      kk
      ff
      D
      qq
      zz
      ll
      File B:
      1
      5
      6
      A
      rr
      ss
      B
      gg
      rr
      D
      mm
      ww
      The Result of Join:
      1
      2
      3
      4
      5
      6
      A
      xx
      yy
      zz
      rr
      ss
      B
      tt
      hh
      kk
      gg
      rr
      D
      qq
      zz
      ll
      mm
      ww

      But when i am doing the same thing with my data i am not getting the desired result

      Instead i am getting 9X more rows than my original file \

       

      Attached is an image of my data