AnsweredAssumed Answered

DataLink filter to return only unique values.

Question asked by dcunningham on Jul 17, 2015
Latest reply on Jul 24, 2015 by dcunningham

Hi Everyone,

 

I have some compressed data in a column in Excel. What I'd like to do is apply a filter expression to it that eliminates all the values that are repeated somewhere within the column, so that I'm just left with a list of values that are present without any repetition. So, for example:

  

09-Apr-15 08:21:3627
09-Apr-15 08:21:5126
09-Apr-15 08:22:0626
09-Apr-15 08:22:2126.5
09-Apr-15 08:22:3625.5
09-Apr-15 08:22:5125
09-Apr-15 08:23:0625.5
09-Apr-15 08:23:2126

 

The above filtered would return 27, 26, 26.5, 25.5, and 25. To be clear, I'm not just trying to eliminate repeated values that appear consecutively using something like ''PrevVal('tag1','*') <> 'tag1', I'm trying to eliminate repeated values for the entire column and just return the first instance of that value or any singular instance, the presence of the value is what's most important to me not the time at which it occurred. The numbers correspond to a certain type of condition, and I just want to which conditions were present during the time range. I feel like this should be doable, I just don't know the expression to get it done and I can't seem to find an example of someone trying to do something similar through my searching.

 

Any help anyone can provide would be greatly appreciated.

 

Dan

Outcomes