How to use the CSV Merge Tool.
Choose whether merging means appending rows or joining by a key. Specify how duplicate keys and unmatched records should be handled.
Make the workflow fit your task.
Choose append or join, define the key and select which side's unmatched records to keep. Inspect duplicate keys before combining tables. Show source labels for conflicting columns and reconcile the output count against the chosen merge relationship.
- What you provide
- CSV tables and join keys.
- What you get
- Merged table with unmatched and duplicate-key report.
See the input and the result.
Illustrative input and output · a teaching example, not a live WebAct run
Example input
Left join two CSV tables on id, with unique keys. Table A: id,name 1,Ada 2,Sam Table B: id,status 1,Active 3,Inactive
Completed example
id,name,status 1,Ada,Active 2,Sam, Reconciliation: two output rows. A key 2 has no B match. B key 3 is outside the left join and is reported separately. No duplicate keys in either input.
Load this input into the prompt, then copy it to WebAct to try the task. Your result may differ from the illustration.
Decisions and troubleshooting.
What happens when both tables contain repeated join keys?
A many-to-many join can multiply rows. Decide whether that relationship is valid before merging or aggregating the inputs.
Why are some records missing after a CSV join?
An inner join excludes unmatched keys. Check whitespace, key types and whether a left or full join was intended.
Try it with your own source.
Replace the example with your material in the task prompt. Keep the requirements you need, then copy the task into WebAct.
Customize and copy the task ↑