<< Click to Display Table of Contents >> Navigation: Reference > Batch processing |
To apply the current transform template file to multiple input files 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.
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.
•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.
In the (pink) input column you can use * and ? wildcards for file name stems, file extensions and Excel sheet names. E.g.:
Input |
Description |
---|---|
/Users/andy/Documents/*.csv |
All files with extension .csv in the Documents folder |
/Users/andy/Documents/d?.csv |
All the files with name 'd' plus a single character in the Documents folder |
/Users/andy/Documents/data.xlsx[*] |
All the sheets in data.xlsx in the Documents folder |
/Users/andy/Documents/*.xlsx[data*] |
All the sheets beginning with 'data' in all the .xslx files in the the Documents folder |
Note:
•If there is more than 1 input column 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.
In the (green) output column you can use the following variables to create your output file name:
Output variable |
Meaning |
Example |
{<input alias>} |
The name of the input file being processed in the column with the corresponding alias. |
If input alias 'orders' is using file |
{date} |
Date processing was carried out in year_month_day format |
2020_04_18 |
{time} |
Time processing was carried out in hours_minutes_seconds_milliseconds format |
15_21_56_599 |
{datetime} |
Date/Time processing was carried out in year_month_day_hours_minutes_seconds_milliseconds format format |
2020_04_18_15_21_56_599 |
Whether an ouput file is created, overwritten or appended to depends on the Write mode of the output item.
Click Process to start processing the rows.
Click Stop to stop processing the rows.
Click Close to close the window.
See also: