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

    Outer Join not merging rows

    Stuart Frew



      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?