You can split an existing list into smaller groups using the Split List action. Splitting a list simply creates smaller groupings of records from the master list associated with the original list. The number of records included in each split list is determined by the Split list size entered when creating split lists. Split lists can be created from any existing list, whether it is a Personal list or a previously executed Criteria Based list.
To split a list:
Click the module tab and click the Lists submenu link.
Search for the list you want to split.
Select the check box next to the list you want to split and select the Split List action. IQ displays the Split Lists dialog.
Enter the size of the split list (not less than 100) in the Split list size field. All split lists will contain the number of records you enter in this field, except for the last one, which will contain the remainder.
Enter a name, up to 30 characters, such as "Split of ALL Workflow", in the Split Lists Name Prefix field. IQ will use this value for each split list name. If you leave this field blank, IQ will use the word "SPLIT" and the list name ID of the original list for each split list name.
Click the Submit button. IQ displays the results of the split lists on the Lists Search Results page.
Split lists are named automatically, based on the value entered (or not entered) in the Split Lists Name Prefix field. The Split list size determines the maximum number of records to include in each of the resulting lists. So, for example:
Splitting a list with a list name ID of 358 that contains 2,568 records using a split list size of 1000 and "Split of ALL Workflow" in the Split Lists Name Prefix field would result in three lists: Split of ALL Workflow 1, with 1000 records; Split of ALL Workflow 2, with 1000 records, Split of ALL Workflow 3, with the remaining 568 records.
Splitting a list with a list name ID of 358 that contains 2,568 records using a split list size of 1000 and NO value in the Split Lists Name Prefix field would result in three lists: SPLIT 358 1, with 1000 records; SPLIT 358 2, with 1000 records, SPLIT 358 3, with the remaining 568 records.
A split list does not include the criteria or list definition of the original list. Like a Personal list or a Merge list, a split list record consists only of the records contained in the list. As such, a split list cannot be re-executed. In order to update a split list, you must re-execute the original list and split it again.
Split lists are sorted in the same order as the original parent list. So, if the parent list is sorted by zipcode, the split lists will also be sorted in zipcode order.