Contributor

Need unique element through versions

Hi!

I've got a module with few dimensions, including versions, I generate code there for a list to update.

So I need to filter unique code. Currently, I use formulae:

IF RANK(1, ASCENDING, SEQUENTIAL, TRUE, 'List name') = 1 THEN 'List name' ELSE BLANK

But it does not work properly through versions (return duplicates)

 

Is there any other way to get unique elements within multiple versions?

 

I would appreciate any assistance!

18 REPLIES 18
Highlighted
Super Contributor

Re: Need unique element through versions

Hi,

 

I'll be helpful if you can create and share an excel mockup of what you're trying to achieve.

 

Thanks,

LipChean

Contributor

Re: Need unique element through versions

Here is the file.

I need to filter unique elements in column CODE

Super Contributor

Re: Need unique element through versions

Hi,

 

If i just look at the first row, what are "BU", "UA", "2610", "1", "302066"?

Why is the Code for row 1 and 2 the same?

Why do you have different separators of _ and *?

Screen Shot 2019-06-22 at 6.24.19 PM.png

Thanks,

LipChean

Contributor

Re: Need unique element through versions

It is the code, that is generated automatically and consist of few codes of other items such as Bussiness unit (bu_ua), product code and others, but this is not the matter.

The matter is that i need to filter unique codes throughout all dimensions including versions.

Thank you.

Contributor

Re: Need unique element through versions

And the mater also is that there might be duplicates in code, so as I mentioned before, I need to filter unique ones

Super Contributor

Re: Need unique element through versions

Hi,

 

What do you mean by 'filter unique codes throughout all dimensions including versions'?

 

Perhaps you can show the expected end results in another screen shot?

 

Thanks,

LipChean

Contributor

Re: Need unique element through versions

Here is the file, please consider

Super Contributor

Re: Need unique element through versions

Hi,

 

 

Screen Shot 2019-06-23 at 9.13.10 AM.png       Screen Shot 2019-06-23 at 9.13.16 AM.png

There are 2 lists, All_Entries corresponds to your longer list; Alphabets corresponds to unique members created from your longer list.

 

Screen Shot 2019-06-23 at 9.13.32 AM.png

The 'Code' line item is of 'Text' format, this is used to create the 'Alphabets' list through import action.

The rest of the formulas are shown.

Screen Shot 2019-06-23 at 9.13.42 AM.png

Thanks,

LipChean

Contributor

Re: Need unique element through versions

Hi, thank you, but this won't work for me.

Because this will do if all letters are in the list 'Alphabets' (you count letters in the list)

if I import new data (letters F,G,H...), code(List) column will be empty for new letters.

I need to filter new unique letters(F,G,H...) that are not in the list yet