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

No.	Field Name	Description
1	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:
1	Get filename from field	Enable this checkbox if you need to get fieldname from a field.
2	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.
1	File or directory	Browse for the file or directory and Add to the list of selected files.
2	Wildcard(RegExp)	If directory is chosen you could filter the files in the directory using regular expression.
3	Exclude wildcard	If directory is chosen you could exclude files with this Regular Expression.
4	Required	Choose Y (from Y/N) if File/Directory is required.
5	Include subfolders	Choose Y (from Y/N) to include subfolders.
Content Tab:
	Rows Count Field:
1	Rows Count Fieldname	Specify a fieldname in which to store the row count.
	Row Separator:
1	Row Separator Type	Specify a Row Separator Type from the list.
2	Row Separator	If Row Separator Type is ‘Tabulation’ provide Row Separator.
3	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:
1	Include files count in output?	Enable checkbox to include no. of files in output.
2	Files Count fieldname	If the above checkbox is selected provide fieldname to store files count.
	Add filename to result:
1	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.