Listware for Excel:Business Coder Tutorial

From Melissa Data Wiki
Jump to navigation Jump to search

← Listware for Excel Reference

Business Coder Navigation
← Listware for Excel Overview
Overview
Tutorial
Steps
Processing Range
Options
Input Columns
Output Columns
Reporting
Review Settings
Processing
Processing Results
Result Codes



LWE BusinessCoder Button.png

After you install Listware and set your License Key, you are ready to use Listware. Follow along with the steps below to perform a sample cleansing on a data set with Business Coder.


Open a Spreadsheet

Open a spreadsheet containing your data in Excel.


Select Business Coder

Select the Listware Ribbon followed by the Business Coder button.

LWE BusinessCoder Tutorial Select.png

The Business Coder panel will open.


Select Data

Choose what data you want to use by click-dragging a box around it and clicking the 'Select Data to Process' button.

LWE BusinessCoder Tutorial SelectData.png

Once your data has been selected, click 'next' to move on to the Cleansing Operations step.


Choose Options

Choose which options you require.

For more information on Melissa Data Credits, please see Credit Costs.

LWE BusinessCoder Tutorial Options.png

Click 'next' to continue on to the Input Columns step.


Input Columns

Specify the input columns you want to process.

For example, if your data has Company, Address, City, State, ZIP, and Phone, you should map these columns by selecting the column in the drop-down boxes next to its corresponding column.

LWE BusinessCoder Tutorial InputColumns.png

Once your input columns have been mapped, click 'next' to continue on to the Output Columns step.


Output Columns

Specify what data you want to output.

LWE BusinessCoder Tutorial OutputColumns.png

Once your output data has been chosen, click 'next' to continue to the Reporting step.


Reporting

Specify if you want a report created and the contents of that report.

When processing is completed, you have the option of having a new sheet created and inserted immediately following the processed sheet. This reporting sheet will contain statistics and settings summarizing the processing run.

LWE BusinessCoder Tutorial Reporting.png

Once you choose what reports you want, click 'next' to continue to the Review Settings step.


Finalize Settings

Review and finalize your settings.

If there are any warnings, they will be listed here. These will need to be resolved before you can process the data.

LWE BusinessCoder Tutorial Finalize.png

Click 'Process!' to begin processing your file. A progress bar will be displayed.

Note: It is strongly recommended that you refrain from editing your spreadsheet while Listware is processing.


Processing Complete

Once processing is complete you can 'Map' the data points, 'Restart', or 'Close' the process.

LWE BusinessCoder Tutorial ProcessingComplete.png

  • Map will map the data points on a web page.
  • Restart will run the process again.
  • Close will close the side bar.


Review

If you chose to create a report in Reporting, you will have a Listware Reporting sheet you can navigate to in your excel book.

LWE BusinessCoder Tutorial Review.png

Here you will see a detailed breakdown of your data and the cleansing process.


Save

When you are satisfied with your data, use the Excel menu to save your spreadsheet.