Vendor File - Active Address

[gfisch13]

Good morning folks, 

I'm working with my vendor master file.  The file includes a new record for each address and the latest (in use) address is noted by the highest number in the ADR_SEQ_NUM field (if there are 5 addresses the value of 5 would note the 'in use' address.

My question is how to limit my table to just those records.  I'm tending to think I need a loop of some sort but I'm not sure how to apply that here.  If there are other suggestions I'm certainly open to those.   The attached screen shot shows my situation.....

Appreciate any input.  Thanks! George

[rwunderlich · Accepted solution]

Load all rows, to create for example "VenMaster",  and then use an Inner Join to trim to just the latest row:

Inner Join (VenMaster)
Load
  VND_ID,
  count(VND_ID) as ADR_SEQ_NUM
Resident VenMaster
Group By VND_ID;

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

[gfisch13]

Thank you for the quick, easy to understand reply.   Worked exactly as intended!!  Appreciate your time!