Re: how to remove duplicate entries
my fault: I said "entries" but actually this is not correct. I already have in the workflow one AL-table-loop and one filter-table-loop on two different tables for my form A. And I read logins from another form B. These are read in the table fields. At the end of my 2 table-loop I have a field which displays logins on my form A. Sometimes I have 2 times the same login. This is because one login could be checked two times. So it is a normal result at the end. But still I would like to remove duplicates at the very end of my workflow ... before I send emails out ... :D Sorry for the confusion. Remedy.maniac Heider, Stephen wrote: serouche, If you know SQL you could write a stored procedure that would identify the duplicates and then update a separate field on the form (ie. Set an Optional Checkbox field to 0). Followed by a filter that would delete each of the records which have a value in this checkbox field. If you need users to be able to run this at anytime trigger it from an Active Link. HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky Sent: Monday, January 21, 2008 6:28 AM To: arslist@ARSLIST.ORG Subject: Re: how to remove duplicate entries Hi, You could create a table-field that sorts its content on the field(s) you want to remove duplicates from. Also include the request-id in one column. Table Field with Columns: - TblColValue - TblColReqID Create a display-only-temp-fields: - TempPrevValue Then you create Active Links for a table-loop-guide: AL 1: Run If: $TblColValue$ = $TempPrevValue$ Action Run Process: @@:Application-Delete-Entry "Form" "$TblColReqID$" AL 2: Run If: Action Set Fields: TempPrevValue = $TblColValue$ Create the Guide and add the above Active Links: Create an Active Link that calls the guide with Table Loop activated. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. dear all, I would like to clean-up duplicate entries in a character field. I must use AL on the web. How can I do this? Through filters I would do something like "RUN PROCESS echo "MYFIELD" | sort | uniq" and that will do but through AL on the web I don't see. Please help. Thank you. serouche /"because there is always a remedy to help you"/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: how to remove duplicate entries
serouche, If you know SQL you could write a stored procedure that would identify the duplicates and then update a separate field on the form (ie. Set an Optional Checkbox field to 0). Followed by a filter that would delete each of the records which have a value in this checkbox field. If you need users to be able to run this at anytime trigger it from an Active Link. HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky Sent: Monday, January 21, 2008 6:28 AM To: arslist@ARSLIST.ORG Subject: Re: how to remove duplicate entries Hi, You could create a table-field that sorts its content on the field(s) you want to remove duplicates from. Also include the request-id in one column. Table Field with Columns: - TblColValue - TblColReqID Create a display-only-temp-fields: - TempPrevValue Then you create Active Links for a table-loop-guide: AL 1: Run If: $TblColValue$ = $TempPrevValue$ Action Run Process: @@:Application-Delete-Entry "Form" "$TblColReqID$" AL 2: Run If: Action Set Fields: TempPrevValue = $TblColValue$ Create the Guide and add the above Active Links: Create an Active Link that calls the guide with Table Loop activated. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. > dear all, > > I would like to clean-up duplicate entries in a character field. > I must use AL on the web. > How can I do this? > Through filters I would do something like "RUN PROCESS echo "MYFIELD" | > sort | uniq" and that will do but through AL on the web I don't see. > Please help. > Thank you. > > serouche > /"because there is always a remedy to help you"/ > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: how to remove duplicate entries
Hi, You could create a table-field that sorts its content on the field(s) you want to remove duplicates from. Also include the request-id in one column. Table Field with Columns: - TblColValue - TblColReqID Create a display-only-temp-fields: - TempPrevValue Then you create Active Links for a table-loop-guide: AL 1: Run If: $TblColValue$ = $TempPrevValue$ Action Run Process: @@:Application-Delete-Entry "Form" "$TblColReqID$" AL 2: Run If: Action Set Fields: TempPrevValue = $TblColValue$ Create the Guide and add the above Active Links: Create an Active Link that calls the guide with Table Loop activated. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. > dear all, > > I would like to clean-up duplicate entries in a character field. > I must use AL on the web. > How can I do this? > Through filters I would do something like "RUN PROCESS echo "MYFIELD" | > sort | uniq" and that will do but through AL on the web I don't see. > Please help. > Thank you. > > serouche > /"because there is always a remedy to help you"/ > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
how to remove duplicate entries
dear all, I would like to clean-up duplicate entries in a character field. I must use AL on the web. How can I do this? Through filters I would do something like "RUN PROCESS echo "MYFIELD" | sort | uniq" and that will do but through AL on the web I don't see. Please help. Thank you. serouche /"because there is always a remedy to help you"/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"