Get Files Rows Count

Description

Get Files Rows Count is a step in the Input Plugin for Process Studio Workflows. Get Files Rows Count step counts the number of rows in a file or a set of files.

Note: This step only works with text/delimited file types.

Configurations

Field Name	Description
Step name	Specify the name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow.
Filename from field:
Get filename from field	Enable this checkbox if you need to get fieldname from a field.
Filename from field	If ‘Get filename from field’ is checked choose field containing the file name.
Selected files:	The following fields are enabled when Get filename from field checkbox is not enabled.
File or directory	Browse for the file or directory and Add to the list of selected files.
Wildcard(RegExp)	If directory is chosen you could filter the files in the directory using regular expression.
Exclude wildcard	If directory is chosen you could exclude files with this Regular Expression.
Required	Choose Y (from Y/N) if File/Directory is required.
Include subfolders	Choose Y (from Y/N) to include subfolders.
Rows Count Field:
Rows Count Fieldname	Specify a fieldname in which to store the row count.
Row Separator:
Row Separator Type	Specify a Row Separator Type from the list.
Row Separator	If Row Separator Type is ‘Tabulation’ provide Row Separator.
Perform Smart Count	Enable this option to identify data after a separator. So that the rows count is not based simply on number of separators but also checks if there is data after separator.
Additional fields:
Include files count in output?	Enable checkbox to include no. of files in output.
Files Count fieldname	If the above checkbox is selected provide fieldname to store files count.
Add filename to result:
Add filename to result	Adds the CSV filename(s) read to the result of the workflow. Filenames in result is a unique list being kept in memory that can be used in the next steps or parent workflow steps or parent process entries.