View previous topic :: View next topic |
Author |
Message |
COpfar
Joined: 22 Jan 2010 Posts: 2
|
Posted: Fri Feb 11, 2011 6:50 pm Post subject: End-date users and varying # of responsibilities. |
|
|
I have a list of 100 accounts and right now it end-dates Account and one or two responsibilities. Some accounts only have two responsibilities and some could have up to 80. How to adjust Data Load to complete this task when each user does not have the same number of responsibilities assigned to them? |
|
Back to top |
|
|
DataLoad Site Admin
Joined: 15 Nov 2005 Posts: 231 Location: Dorset, UK
|
Posted: Mon Feb 14, 2011 5:50 pm Post subject: |
|
|
One approach is to use a load that repeatedly queries back the user, queries the responsibility and then end dates it. That isn't as efficient as querying back a user once and end dating multiple Responsibilities but it makes for a simple load. If you are using Forms Playback then this load will run very fast despite the inefficiency or if you have very high volumes and some technical knowledge then you could script this in DataLoad Scripting.
Thanks,
Jonathan Stuart |
|
Back to top |
|
|
|