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.
TSV CSV
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 in the target platform in advance.
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 from Survey Records TSV. 2D frequency distribution.
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. Frequency distribution.
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 distribution tables and histograms.
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 each combination of Client-Y and Store-X” is aggregated from “Sales log TSV”.
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 aggregated from “Sales log TSV”. Grand Total Tabulation.
TSV String, Verify Rectangle
Verifies that the cells are in a matrix format. If the number of cell values are different for each row, tabs will be added. It is also possible to get the number of rows and columns after formatting. No trailing newline will be added to the verified TSV.
TSV String, Calc Changes in Two Numeric Columns
Calculates the difference and rate of change for the two numeric columns in the TSV. Adds the calculated value to the rightmost column. It realizes month-on-month and year-on-year automation.
Two TSV Strings, Join on Common Column
Merges two TSVs based on a common key-field. Keeps all the rows from TsvA (left table) and brings in any matching rows from TsvB (right table); Left Outer Join. Neither TSV needs to be sorted. Only the upper row in TsvB will be matched.
Multiline String, Get Range Lines
Extracts the specified range of rows. The range is specified by Begin Index and End Index. The index is zero-based and the index on the first row is zero. Note that the row specified by the End Index is not included in the range.
Multiline String, Delete Empty Lines
Removes all blank rows. Line breaks at the end of the text (including TSV and CSV) are also removed. If there is even one single-byte space on the line, it will not be deleted.
Converter, CSV-String to TSV-String
Converts a CSV string to a TSV string. The TSV is output as the simplest tab-delimited string. If the field contains line breaks or tab, they are replaced with spaces. If the double-quotes in the input CSV are not escaped, the output will be unintended.
TSV String, Convert
Changes the column order of TSV text. The new order is specified by enumerating the column IDs of the original TSV, like “0,1,3,0”. The new TSV text can also be stored in formats such as TSV file format and CSV file format.
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 same rules.
Converter: TSV-String to Table
Converts a TSV String to Table-type data. The string values of all cells in the TSV string are copied over to Table-type data B. If there is an inconsistency in the Table column design, an error may occur.
MoneyForward Journal, Create
Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only batch sales invoices but also invoices that are prorated for each month.
Two Tsv Strings, Extract Cell-Matched Lines
Compares a specific column of TSV string A with a specific column of B and extracts the rows of B that have a matching cell in A. If A and B match exactly, all lines in B are returned. If they are completely different, an empty string is returned.
Two Tsv Strings, Extract Cell-Mismatched Lines
Compares a specific column of TSV string A with a specific column of B and extracts the rows of B that do not have a cell match for A. If A and B match exactly, an empty string is returned. If they are completely different, all lines in B are returned.
Master Table, Create by TSV String
[su_box title="Master Table, Create by TSV String" style="soft" box_color="#ff99ff" title_color="#000000" radius="0"] Creates a new master file (OptionsXML) by referring to the TSV String. The specified column data are set as Master IDs, and the other data is set as Master Labels. By placing a [Service Task (Choices Update)] in the downstream process, the update task can be automated.[/su_box]
Image-Charts: Bar Chart, Create
Creates a Bar/Line Chart from numeric TSV (population by country, monthly sales) using Image-Chart. The Y-axis tick marks are automatically generated. The X-axis tick marks are refered to the first line of the TSV. The image is output in PNG format.