11/26/2024 3:25:15 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum for off topic and general discussion. View the code of conduct for posting guidelines.
|
|
|
|
Compare 2 data fields in SLx
Posted: 07 Apr 09 9:36 AM
|
Being a "newby," I'm not sure where to post this question...
How can I compare the contents of two fields in the same record and create a group of the records with equal data? What I'm trying to do is find anyone with Address 1 equal to Address 2, create a group of the equals, then erase the dat from Address 2.
Thanks,
Ted |
|
|
|
Re: Compare 2 data fields in SLx
Posted: 07 Apr 09 11:30 AM
|
Somewhat easy.
If you build the group, and add both fields to the layout, you could then check the SQL and determine the Table Alias for the fields you will be comparing.
Then add a condition for one of the fields, set the operator to Equals (=), check the Use as Literal checkbox and then write the opposite field on the Value box with the alias (e.g. A3.MYDUPFIELD).
After that, you could check the SQL statement for a group one more time to determine if it looks correctly.
From there, you could use the Replace Data Wizard (on the Menu under Tools/Maintenance/Replace Data...)
Alternatively, you could always use SQL statements to fix the data. If you have a synchronizing environment, execute them via the Workgroup Administrator and make sure you select to Send it to all your Remote users.
|
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|