Erik Lee replied to Erik Lee's discussion Checking and handling duplicate keys in DMX
"Syncsort tech support helped me out. Here's their answer below:
"This is called a "keybreak" and we have an example of how to implement it in DMExpress.
You will want to sort your input by the first 2 fields, then use User Defined Value functions to…"
Jan 7
Erik Lee replied to Erik Lee's discussion Checking and handling duplicate keys in DMX
"Hopefully I can explain it a bit further.
Here's a representative example of the source, and of the desired target data. I'd like to add to the target a sequence number for each record that shares a duplicate id-datetime combined key. When a new com…"
Jan 6
Erik Lee posted a discussion in DMX
I have source data that requires that I add a sequence number for duplicate keys. Given a sorted dataset, is there a way in DMX to do this?Thanks!
Jan 3
Erik Lee is now a member of Syncsort Community
Aug 12, 2015