5 Replies Latest reply: Dec 29, 2014 10:12 AM by Stuart Frew RSS

    Outer Join not merging rows

    Stuart Frew

      Hi,

       

      I have two tables that have the same field name but when I load them and attempt an outer join Qlikview is creating new rows not merging the data. This has been checked by brining in a RowNo() field.

       

      The field in question is called PARTY_KEY.

       

      I have tried setting the format to num and text for both tables but the data still does not merge.

       

      Any thoughts on how to force a join?

       

      Thanks

      Stuart