In our existing Appian user accounts, we have duplicated users with the same emp

Will Teoh over 11 years ago

In our existing Appian user accounts, we have duplicated users with the same employeeID (set as customField1). I have to do housekeeping to deactivate the duplicated user accounts based on the duplicated employeeID. What is the best way to do it?

I have looked at intersection, union, wherecontains, contains, distinct... But I have no idea how to implement any of these function to achieve my objective. Any ideas?

Thanks!
...

Discussion posts and replies are publicly visible

Parents

0 Will Teoh over 11 years ago

@michael.tan thanks for your reply. I am still looking into this as I havent fix the issue yet. My employee IDs have leading zeros, thus it is in text. I saw you have a sum function in your rule. any diff if im passing in a text datatype?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Will Teoh over 11 years ago

@michael.tan thanks for your reply. I am still looking into this as I havent fix the issue yet. My employee IDs have leading zeros, thus it is in text. I saw you have a sum function in your rule. any diff if im passing in a text datatype?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data