Jobs: the same step on every row

Some work is the same small step repeated a thousand times: look something up for each row, check each row against a rule, fill in a missing value for each row. That is a Job.

Steps

• Open the file with the rows.
• Describe the step for one row, and say "for every row".
• Carry on with other work. The Job runs in the background. The Jobs button in the bottom bar shows progress.

What comes back

Your rows, with the new columns filled in, and a Status column on every row: done, or the reason it was not done. Rows that failed are grouped by reason. Weaver works out what went wrong, fixes it, and reruns only those rows.

You can ask for the result as a new file, or have the answers written back onto your own rows, matched by the row's key, with your existing columns untouched.

Good uses

• Fill in the district for every pincode.
• Check every GST number's format and flag the bad ones.
• Read every invoice in a folder into one table. See Read a folder of documents.
• Fetch today's status for every order number from your system's web API.