Contact Zone:Excel Output: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
[[Contact Zone:Reference|← Contact Zone Reference]]
{{ContactZoneBasicsNav
 
|OutputCollapse=
{| 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 mw-collapsed" 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" style="width:100%;"
|- align="left"
! style="color:black;"|Output
|-
|[[Contact Zone:Excel Output|Excel Output]]
|-
|[[Contact Zone:Text Output|Text Output]]
|}
|-
||[[Contact Zone:Reporting|Reporting]]
|}
 


{{CustomTOC}}
{{CustomTOC}}

Latest revision as of 00:48, 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 output data to Excel files.

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

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

Then create a hop from the previous transformation step to this output step: Shift-left click and drag from the previous step to this step.

Configuring the Step

1. Double-click the Excel Output 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 output window. Here we need to setup:

  • Step name - If needed, we can change this name to be more descriptive.
  • Filename - Here you designate the output filename and location.

3. Click the Browse... button and navigate to the desired file location. Name the file, then click Save.

4. Select the Fields tab.

5. Click Get Fields. This will populate the fields with information taken from the previous step, and appear in this output file.

6. Click OK to finish defining the Excel Output Step.