| Import Wizard Example 2
Import Example 1: Multiple Lines Per Record
Import Example 2: Multiple Headers
Import Example 3: Address List
Import Example 4: Delimited Web Server Log File
Import Example 2: Multiple Headers
This example shows the header import capabilities. This report has two headers, the product and the company. Import Wizard allows an unlimited number of headers and/or footers in an import. Also note that this report implicitly repeats the salesman name, i.e. on the second and third record the name is ommitted. This can be imported correctly using Import Wizard as shown by the resulting table.
File For Import
Product Sales Report Page: 1
Company: XYZ Company For the month ended:09/30/98
==========================================================
Sales Person Date Qty Price Class
----------------------------------------------------------
Product: Tape
Doe, John 09/23/98 1,120 11,225.60 AC
09/24/98 21,123 233,112.67 VA
09/27/98 23 32.22 CS
Wacks, Gene 09/01/98 3,766 3,455.55 AC
Peters, Kate 09/30/98 4,000 3,999.44 VA
09/02/98 1,653 6,775.55 OT
Product: Stapler
Perrol, Barb 09/13/98 3,320 11,225.60 AC
Zonker, Pete 09/11/98 766 453.53 AC
09/20/98 1,455 2,543.43 VA
Perkins, Joe 09/12/98 23 23.55 OT
| |
Table Imported with Import Wizard
Company |
Product |
Sales Person |
Date |
Qty |
Price |
Class |
XYZ Company |
Tape |
Doe, John |
9/23/97 |
1120 |
11225.6 |
AC |
XYZ Company |
Tape |
Doe, John |
9/24/97 |
21123 |
233112.67 |
VA |
XYZ Company |
Tape |
Doe, John |
9/27/97 |
23 |
32.22 |
CS |
XYZ Company |
Tape |
Wacks, Gene |
9/1/97 |
3766 |
3455.55 |
AC |
XYZ Company |
Tape |
Peters, Kate |
9/30/97 |
4000 |
3999.44 |
VA |
XYZ Company |
Tape |
Peters, Kate |
9/2/97 |
1653 |
6775.55 |
OT |
XYZ Company |
Stapler |
Perrol, Barb |
9/13/97 |
3320 |
11225.6 |
AC |
XYZ Company |
Stapler |
Zonker, Pete |
9/11/97 |
766 |
453.53 |
AC |
XYZ Company |
Stapler |
Zonker, Pete |
9/20/97 |
1455 |
2543.43 |
VA |
XYZ Company |
Stapler |
Perkins, Joe |
9/12/97 |
23 |
23.55 |
OT |
Example 1 2 3 4
|