Capture the first value of duplicates

[nareshthavidishetty]

Hi,

We need to capture the first value from the list of duplicates.

We have load the data from different legacy systems one system load supplier as ex: Rcoks Inc and other system as Rcoks Ltd.

The Supplier ID is same for both ex: 12345

While loading the data into qlikview the output  looks like below.

Here we need for a unique Product_ID we need to map the unique Supplier.

So we planned to consider the first record of supplier out of three listed in above screenshot as unique supplier.

Problem scenario:

If we need to calculate top 10 sales by supplier the above three in screenshot occupies 3 ranks individually means same supplier got three ranks for same sales.

Thanks..

[tresesco · Accepted solution]

Try using loading FirstValue - script function ‒ Qlik