Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 499
  • Last Modified:

unique entries in a variant

Is there a way to leverage variants to deal with unique data? Example: If I pull the dept names for a list of people, but only only want to store each dept name once. Currently my code sorts the data and does compares of the current Dept  to the last one used.
0
BillTr
Asked:
BillTr
  • 2
2 Solutions
 
fgrushevskyCommented:
what language are you using? can you just do @unique(deptnames) ?
0
 
Sjef BosmanGroupware ConsultantCommented:
Or, 100% equivalent to theprevious post, but in LotusScript:
      v= Eval("@Unique(deptnames)",doc)
or
      v= Eval(|@Unique("| & (Join(deptnames,|":"|) & |")|)
depending on where the values are.
0
 
CRAKCommented:
Ehhh Sjef, is there anything wrong with ArrayUnique(sourceArray [,compMethod ])?
(nothing personal, buddy!)
0
 
Sjef BosmanGroupware ConsultantCommented:
Ehm, well, now, right, oooops... Just wanted to show that "clever" things can be done using Eval()... Not so clever after all, apparently...

Is there a backdoor in this room??
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now