How to merge rows with the same ID on non-null Fields?

[Rania]

Hi Qlik Community,

Need your help in merging rows using the same ID which  is in my case the "Key" field.

This is what I'm getting now :

This is what I'm expecting:

PS: I did use the join and it's behaving as the Concatenate function, the rows did not get joined

[rwunderlich · Accepted solution]

You will need to merge using Group By and then join. Like this:

Final:  // Load the dimension fields
Load Distinct Key ClosingDate, EventDate, OpeningStock, Location, OTIN, ClosingStock
Resident mydata
;

Join (Final)
Load Key, 
  Max(Shipped) as Shipped
  Max(Blocked) as Blocked,
  Max(Received) as Received
Resident mydata
Group By Key
;

Drop Table mydata;

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com