-
Master Table: List All Options as TSV String
Includes the master table on Workflow Platform as a string property of the process. The IDs and Labels are concatenated into TSV (Tab-Separated Values) and stored into Multiline-String…
-
Questetra BPMS #Process: Kick HttpStartEvent by TSV
Kicks HttpStartEvent with the specific line data of TSV. When assuming batch start using multiline TSV data, place it in a loop structure. LineIDs start at zero.
-
Singleline CSV String, Extract Cell
Extracts the cell value of the specified ID, starting from zero. The extracted cell string can be stored not only in the String-type data but also in the…
-
Files, Duplicate
Duplicates File-type data. All files stored in Data Item A1 (Original Files) will be copied over to Data Item B1 (Clone Files). Also possible to change the file…
-
TSV String, Filter by RegExp
Narrows TSV text to column matched rows only. A regular expression (RegExp) can be specified as the match condition, and the column value is matched for each row.…
-
TSV String, Filter by Keywords
Filters TSV text to column-matched lines only. The match condition can be either “equals”, “contains”, “begins with”, or “ends with”. A case-insensitive filter can also be specified. It…
-
Text Files, Convert Character Encoding
Converts text files charset (Coded Character Set). For example, converts UTF-8 encoding to Shift_JIS or UTF-16. If multiple files are attached, all will be converted according to the…
-
TSV String, Remove Column-Duplicate Lines
Extracts and deletes rows with duplicate column elements. In forward mode it keeps the first row, in reverse mode it keeps the last row. Note that “ABC” and…
-
String List, Check for Existence of Search String
Checks for the existence of string elements in the list that match the search string.
-
TSV String, Convert date data to yyyy-MM format
Converts the date data in the specified column to yyyy-MM or yyyy format and appends the value to the end of all lines.
-
Google Sheets #Row_Range: Delete
Deletes rows in the specified range. Existing cells will be shifted upward. Both the start and end rows are specified by zero-based index. For example, “startIndex: 0, endIndex:…
-
Questetra BPMS: Process, Batch Extract as TSV
Extracts process data as a multiline TSV string from local or remote workflow platform via API. Field-Items are specified in CSV format such as “string:0,date:2,select:3”. Range is specified…
-
String, Batch Add Thousands Separators
Detects numbers with more than three digits in the text and adds thousand separators to each number. A comma, dot, or space can be specified as the digit…
-
Converter: Multiline-String to Singleline-CSV-String
Converts a multiline string to a CSV string. Converts each row of a multiline string as the value of each cell in the CSV. If commas are included…
-
TSV String, Sum Numeric Column
Sums the values in the numeric column in the TSV. If the numeric field contains commas, they will be removed and then parsed. If you need to add…
-
Questetra BPMS #Process: Batch Extract by Filter as TSV
Extracts process data that match the specified saved filter. Stores the extracted data list as a TSV string. The filter is specified by ReportID which must be saved…
-
TSV String, Create Cross Table of Count
Aggregates the count of data by 2 aggregation-key columns: Pivot table. Count and Percentage are tabulated as a cross table TSV. Eg, Survey Results TSV is automatically generated…
-
TSV String, Create Summary Table of Count
Aggregates the count of data by aggregation-keys. Count and Percentage are tabulated as a summary table TSV. Eg, Survey Results TSV is automatically generated from Survey Records TSV.…
-
TSV String, Switch Rows and Columns
Switches the row and column indices of the rectangle TSV. The output matrix (Transposed Matrix) is obtained by changing cell(x,y) to (y,x). Used for data arrangement for frequency…
-
TSV String, Create Cross Table for Numeric Column
Aggregates the values in a numeric column by 2 aggregation-key columns: Pivot table. Sum, Percentage, Count and Average are tabulated as a cross table TSV. Eg, “Sales for…
-
TSV String, Create Summary Table for Numeric Column
Aggregates the values in a numeric column by aggregation-keys. Sum, Percentage, Count and Average are tabulated as a summary table TSV. For example, “Sales for each client” is…