DocsStart

Your first job

Open a file, ask Weaver one question in your own words, and check the answer. Three minutes, using an invoice sheet as the example.

This takes about three minutes. Use any Excel or CSV file you have. The example below uses a sheet of invoices.

Step 1. Open the file

Drag the file onto the Dataweaver window. Or open the File menu and choose Open File. The file opens in the middle of the screen, in rows and columns.

Step 2. Ask

Weaver is the panel on the right. If you do not see it, press ⌘K on Mac or Ctrl+K on Windows. Type your question the way you would say it to a colleague. Then press Enter.

Which invoices are not paid, and what is the total?

Step 3. Watch it work

Weaver shows each step it takes: what it looked at, what it found, and what it did next. This usually takes under a minute. You can press Stop at any time.

Step 4. Check the answer

The answer is a short piece of text, and often a table. Every number in the answer is a link. Select a number and Dataweaver shows the rows it came from. Do this for one or two numbers the first time. It is how you learn to trust the tool.

Step 5. Keep the result

If Weaver made a table or a file, it appears above the conversation. Press it to open it as a sheet, or press Export to save it as Excel, CSV, JSON or XML.

Weaver never changes your original file. Every result is a new file. If you do not like the result, just do not save it.

You askWhich invoices are not paid, and what is the total?

Before

InvoiceCustomerPaid onAmount
INV-1041Meridian Textiles18-03-202648,200
INV-1042Ashwin Traders12,750
INV-1043Nilgiri Foods₹9,400
INV-1044Kalyani Metals02-04-202666,000

After

InvoiceCustomerAmount
INV-1042Ashwin Traders12,750
INV-1043Nilgiri Foods9,400

2 unpaid invoices. Total ₹22,150. One amount was typed with a ₹ sign; Weaver read it as a number anyway.

Was something unclear on this page? Write to us and we will fix the page.