Contact Zone:Excel Input: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
Line 1: Line 1:
[[Contact Zone:Reference|← Contact Zone Reference]]
{{ContactZoneBasicsNav
 
|InputCollapse=
{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
}}
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Contact Zone Basics Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[Contact Zone:Basics|Overview]]
|-
|[[Contact Zone:Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Input
|-
|[[Contact Zone:Excel Input|Excel Input]]
|-
|[[Contact Zone:CSV Input|CSV Input]]
|-
|[[Contact Zone:MySQL Input|MySQL Input]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|MD Components
|-
|[[Contact Zone:Contact Verify|Contact Verify]]
|-
|[[Contact Zone:Global Verify|Global Verify]]
|-
|[[Contact Zone:IP Locator|IP Locator]]
|-
|[[Contact Zone:MatchUp|MatchUp]]
|-
|[[Contact Zone:Personator|Personator]]
|-
|[[Contact Zone:Presort|Presort]]
|-
|[[Contact Zone:SmartMover|SmartMover]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Output
|-
|[[Contact Zone:Excel Output|Excel Output]]
|-
|[[Contact Zone:Text Output|Text Output]]
|}
|}
 


{{CustomTOC}}
{{CustomTOC}}

Latest revision as of 00:45, 3 January 2017

← Contact Zone

Contact Zone Basics Navigation
Overview
Tutorial
Input
Excel Input
CSV Input
MySQL Input
MD Components
Contact Verify
Global Verify
IP Locator
MatchUp
Personator
Presort
SmartMover
Output
Excel Output
Text Output



Contact Zone can use Excel files as input.

This step is located in the View/Design Pane, under the Design tab, in the Input folder, with the name Excel Input.

To get started, Left-click drag and drop the Excel Input from the View/Design Pane to the Transformation Pane.

Configuring the Step

1. Double-click the Excel Input Step. (Or right-click the Step and select Edit step.)

2. Here the configuration window that belongs to this type of Step will appear. In this case, the Excel Input window. Here we need to setup:

  • Step name - If needed, we can change this name to be more descriptive.
  • File or directory - Here we link this Step with our input data file.

3. Click the Browse... button and navigate to the desired data file. Then click Open.

4. Click Add to add the file to the Selected files: list.

5. You now need to add sheets from the selected excel file. Click on the !Sheets tab.

6. Click on Get sheetname(s)... to add sheets. This will cause the Enter list window to appear.

7. In the Enter list window, select the desired sheets to add, moving them from the Available items: list to the Your selection: list through the use of the >, >>, <, or << buttons. One (>, or <) moves one selected sheet to the indicated list. Two (>>, or <<) moves all sheets to the indicated list.

8. Once the desired sheets are under Your selection: click OK.

9. Select the !Fields tab.

10. Click Get fields from header row.... This will populate the fields with information taken from the header row in the excel file.

11. Click OK to finish defining the Excel Input Step.