Batch processing

<< Click to Display Table of Contents >>

Navigation:  Reference >

Batch processing

To apply the current .transform file to multiple input files/sheets select File>Batch Process... . The Batch Process window will appear with a column for each input item and a column for each output item. The Alias for each item is displayed in the column header.

 

join multiple files

 

Note:

All input and output items must have an alias.

An output item can't have the same alias as another output or input item.

Disconnected input and output items are not shown.

Output items with Write mode=Disabled are not shown.

 

Click Add to add a new processing row.

 

Click Remove to remove the selected processing row(s).

 

Click Clear to remove all processing rows.

 

Check clear 'Append' outputs before first append if you want to clear output files you are appending to before the first append.

 

Check log results to if you want to log the results to a text file. Set the file location and set the write mode to Overwrite or Append. You can use {datetime}, {date} and {time} in the file location.

 

In the input column(s) you can use * and ? wildcards for file name stems, file extensions and Excel sheet names. E.g.:

 

Input

Description

C:\Users\andy\Documents\*.csv

All files with extension .csv in the Documents folder

C:\Users\andy\Documents\d?.csv

All the files with name 'd' plus a single character in the Documents folder

C:\Users\andy\Documents\data.xlsx[*]

All the sheets in data.xlsx in the Documents folder

C:\Users\andy\Documents\*.xlsx[data*]

All the sheets beginning with 'data' in all the .xslx files in the Documents folder

 

Note:

If there is more than 1 input column on a row that specifies multiple files or sheets, then an output will be created for each possible permutation of input files/sheets in the row. E.g. 3 input files from column 1 x 4 sheets from column 2 = 12 outputs to process.

Excel sheet names are not case sensitive.

You cannot use wildcards for folder names.

Batch processing will ignore files in sub-folders. Add them as extra rows.

All the files input to an input item or output from an output item should be the same file type as the original.

 

In the output column(s) you can use the file name variables to dynamically change output file names based on input file names.

 

You can write to multiple sheets of an Excel file.

 

This example shows using a wildcard for the input file name and sheet and file name variables to set the output file name based on the input file with alias sales:

 

batch process Excel sheets

 

But make sure to set the corresponding output Write mode=Overwrite/Sheet.

 

Click Process to start processing the rows.

 

Click Stop to stop processing the rows.

 

Check make a sound on completion if you want to play a sound when all processing is finished.

 

Click Close to close the window.

 

Note:

Whether an output file is created, overwritten or appended to depends on the Write mode of the output item.

We recommend you output to a different folder than the one the input files are in.

 

See also:

Video: Batch processing

Batch processing examples

Command line arguments