CSV two table associations
Press the specified key column to make a left connection or internal connection to the two CSVs, and organize the corresponding data.
CSV two table associations User manual
- Fill in the parameters or select the file according to the form, and check the unit and format first.
- Match the number of column 1 of the data table with the number 1 column of the main table, and merge the data fields.
- Click the processing button to view the results, you can copy or download and save.
Calculation method and processing rules
The first line is used as the header, and the original text of the keys is precisely matched; the right table key must be non-empty and unique, avoiding unexpected expansion of the row.
scope of use
Do not automatically go to spaces, do not automatically turn numbers; empty keys do not match. Result field protection table formula prefix.
Why doesn't numbers 001 and 1 match?
The tool is matched according to the original text, and the number is not converted into a value, and the spaces are not automatically deleted, so as not to merge the records by mistake. The data table must provide a unique non-empty key; the main table duplicate keys allow the same data to be associated with the same data.
Will the input content be saved on the server?
This tool handles input in the browser, and does not upload files or form content. Typing practice scores are only saved in the native browser.
Why may the result be different from other tools?
Do not automatically go to spaces, do not automatically turn numbers; empty keys do not match. Result field protection table formula prefix. Please compare the input unit, rounding method, applicable rules and data version first.