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.
TSV CSV
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 type.
Google Sheets: Values, Export as TSV
Exports the values in the rectangular range as TSV text, which has the same number of tab delimiters on each line. Empty cells are regarded as the null string. Two range export are also supported: e.g. Freezed headings and recent data.
TSV String; Re-order Columns
Extracts a new TSV string re-arranged by a column ID list from TSV string. ID repetition in the list is also possible. It can be used to narrow down necessary information or conform to the format. Removes whitespace from both ends of a string.
TSV String, Filter by Numeric
Filters TSV strings using a numeric range. Only the rows where the specified numeric column is included in the numeric range are output. If you want to OR multiple ranges, specify them in comma separated form like “-100<36.4,37.5<100".
Converter (Table type data to Excel-CSV File)
Stores the values of a Table-type Data Item in a File-type Data Item as an Excel compatible CSV. Files are added and existing files are not affected.
Google Sheets: Sheet Row, Update with Singleline TSV
Updates a Google Sheet with a single line of TSV data. Searches for an A-Column cell that exactly matches the first value of the TSV and overwrite only the first occurrence. The values will be parsed as if they were entered manually by the user. If no matching line exists, it will be appended at the end.
Multiline String, Dequeue First
Removes the first line from the multiline string. One line less than the original string. By placing in a loop flow or in a recursive workflow, data list can be processed sequentially.
Singleline TSV String, Extract Cell
Extracts the cell value of the specified ID. The ID starts from zero. The extracted cell string can be stored not only in the STRING type data but also in the NUMERIC type, DATE type, DATETIME type, SELECT type, USER type, and ORG type data.
Google Sheets: Sheet, Append TSV
Adds the TSV dataset after the last row. New rows will be inserted into the sheet if necessary. Only the specified columns of TSV are added, column ID with an identifier “d” as Datetime, and column ID with an identifier “n” as Numeric; eg “0,2d,5n”.
Master Table, Create by TSV String
Creates a new master file (OptionsXML) by referring to TSV String. The specified column data are set as Master IDs, and the others are set as Master Labels. For automation, place [Service Task (Choices Update)] downstream.
MoneyForward Journal, Create
Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only invoices that are booked as single sales record, but also invoices that are booked as monthly sales records.
Converter: Table to TSV-String
Converts Table-type data to TSV String. The string value of all cells in the Table-type data is copied over TSV string B. Cells with no input are regarded as empty strings.
Converter: TSV-String to Table
Converts TSV String to Table-type data. The string value of all cells in the TSV string is copied over Table-type data B. If there is an inconsistency in the Table column design, an error may occur.
Two Tsv Strings, Compare Numeric Cells
Compares numeric column strings in TSV-A and TSV-B, and lists the amount of change from A to B. If there is no string that matches the key column of A, it will not be listed. If there are multiple matches, it will be compared with the key above.
Two Tsv Strings, Extract Cell-Mismatched Lines
Extracts B lines that DO NOT exist in A-Cell with comparing the specific column of TSV-A and the specific column of TSV-B. If A and B match exactly, an empty string is returned. If they are completely different, all lines in B are returned.
Two Tsv Strings, Extract Cell-Matched Lines
Extracts B lines that DO exist in A-Cell with comparing the specific column of TSV-A and the specific column of TSV-B. If A and B match exactly, all lines in B are returned. If they are completely different, an empty string is returned.
TSV String, Filter Out by Text
Filters out TSV lines by any search text (Exclude Filter). Only lines that DO NOT contain the search text in the specified column are output. If OR search with multiple texts, specify them as a comma-separated list such as “USA,U.S.,United States”.
TSV String, Filter by Date
Filters TSV strings using a date range. Only the rows where the specified date column is included in the date range are output. If OR multiple ranges, specify in comma separated like “2020-01-01<2020-01-07,2020-01-21<2020-01-27".
TSV String, Filter by Datetime
Filters TSV strings using a Datetime range. Only the rows where the specified Datetime column is included in the Datetime range are output. If OR multiple ranges, like “2020-01-01 00:00<2020-01-07 23:59,2020-01-21 00:00<2020-01-27 23:59".
TSV String, Create Cross Tab for Numerical Sum
Creates a crosstab (pivot table) for numeric fields in TSV data. For example, the “Amount” in the order history (TSV) is aggregated on two axes, “Responsible” and “Product”. The fields for X-axis and Y-axis aggregation are specified by TSV field ID.