2021-08-30 (C) Questetra, Inc. (MIT License)
The Add-on import feature is available with Professional edition.
- When the process reaches this automated task, TsvA and TsvB are automatically combined.
- They are combined by the so-called “left outer join”, and a part of TsvB is taken in based on TsvA.
- TsvA: Sales log, Monthly sales data, Access log, etc.
- TsvB: Product master, Previous month sales data, White list, etc.
- TSV (Tab Separated Values) text assumes rectangular data.
- Data that is not rectangular is automatically formatted with empty characters.
- Blank lines (including the end) are ignored.
- Set the column ID (starting with zero) for the common columns used for matching.
- For each data in the TsvA common column, a matching search is performed for the TsvB common column.
- The matching is executed in order from the top line, and the search ends as soon as it is found.
- The matching is case sensitive.
- Set the column IDs to be joined in CSV format. (TsvB columns to be imported)
- If not set, all columns in TsvB will be merged. (including common columns)
- If there is a blank line in the input TSV text, it will be skipped.
- The line feed code for the last line is not added either.
- The number of cells in the (merged) output TSV is uniform for each row. (Rectangle Matrix)
- If the number of cells in TsvA is not uniform in each row, blank strings will be added.
- As many empty strings are added to the unmatched TsvA rows as the number of join columns.
- The number of cells in the output TSV (combined TSV) is uniform for each row.
- To combine non-empty strings, set the alternative strings in CSV format.
- If the list of alternative strings is insufficient, the final string is repeatedly assigned.