Configuring the output component and executing the Job

Procedure

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 it.
The tDataShuffling component shuffles data in the selected columns and writes the result in an output file.
Right-click the output component and select Data Viewer to display the shuffled data.

tDataShuffling outputs shuffled data. tDataShuffling shuffles values within the first group of columns (credit_card) and within the second group of columns (lname, fname and mi).

The shuffling process only applies to the rows sharing the same values for the country column, as defined in the component advanced settings.

Sensitive personal information in the input data has been shuffled but data still looks real and consistent. The shuffled data is still usable for purposes other than production.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!