AX1189
You can use file processing to refresh the file and then perform a save-to-database. Multipass processing can be used to iterate this action over many passes, processing different data in each pass.
There are two different file processing types for saving data:
- Save Data: Save data to the database as part of regular or multipass processing. All normal multipass settings and behaviors apply. This is the standard option for saving data using file processing.
- Save Data in Batches: This is a specialized multipass processing option that uses an Axiom query to define the records to process, and then processes those records in batches—meaning, multiple records are included in each pass. Although the processing iterates over many passes, normal multipass settings and behaviors do not apply. This option is intended for specialized use cases where many records are being processed but processing does not depend on filtering each pass for a particular dimension element.
Save-to-database setup for file processing
The relevant sheets in the file must be enabled for Save Type 1, and set up with save-to-database tags.
Only Save Type 1 processes are performed when using file processing. If sheets in the file are enabled for other save-to-database processes, those processes are ignored.
All sheets in the file will be processed. If the file has multiple sheets that are enabled and configured for Save Type 1, all those sheets will save data to the database during this process.
NOTE: The [Delete] tag for Save Type 1 is not supported for use with multipass file processing.
