topic Re: Vendor File - Active Address in QlikView

Vendor File - Active Address

gfisch13 — Sat, 16 Nov 2024 01:25:36 GMT

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

Re: Vendor File - Active Address

rwunderlich — Fri, 24 Jan 2020 14:03:20 GMT

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

Re: Vendor File - Active Address

gfisch13 — Fri, 24 Jan 2020 14:46:05 GMT

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