Double-click the tFileOutputExcel component
to display the Basic settings view and define
the component properties.
- Set the destination file name as well as the sheet name and then select the Define all columns auto size check box.
Save your Job and press F6 to execute
The tVerifyEmail component analyzes email addresses and corrects those that do not match what you have defined in the local and domain part options.
Right-click the output component and select Data
Viewer to display the formatted email addresses.
tVerifyEmail matches input addresses against the rule you set in the LOCAL part options section and the parameters you set for the domain names.The VerificationLevel output column returns the status as VALID, INVALID, CORRECTED and REJECTED according to what you set/selected in tVerifyEmail basic settings.All email addresses labeled as CORRECTED have a suggested address in the SuggestedEmail output column.