This content has been marked as final. Show 5 replies
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?