2 Replies Latest reply on May 21, 2016 8:52 AM by Mahfooj Khan

    Multiple records due to cross join

    kanchan kamat

      Hi All,

      We have the following requirement :

       

      Table A joined to table B  (1:n)

      Table A joined to table C  (1:1)

       

      What we want in our report is multiple records of first join and only one corresponding record of the second join.

       

      But currently what we are getting is multiple records from the second join instead of getting single record because of cross-join happening.

       

      Could you please suggest some way as how to implement this in tableau data source.

       

      Thanks & regards,

      Kanchan