Consumption Analytics Documentation

Home > Documentation for older versions > Cloud Cruiser 4 > Collecting, transforming, and publishing > ETL workbooks > Working with flows > Copying steps and processors

Copying steps and processors

Table of contents
No headers

Copying steps and processors can save you time and effort. If you know that an existing workbook step would be useful with minimal editing in the same workbook, consider copying that step. For example, you might have a Publish Data step that is essentially the same for different flows in the same workbook. Similarly, you can copy Transformation step processors for reuse in a different  workbook. For example, you might have Transformation steps for complex billing rules, and different workbooks for each of several data sources. 


To copy a step to the same workbook

  1. Right-click the step you want to copy, and select one of the following options:
    • Copy Step > To <name_of_sheet>, where <name_of_sheet> is the name of an existing sheet in the workbook.
      The step is copied to the specified sheet as the last step in the flow.
    • Copy Step > To New Sheet.
      A new sheet is created, with the copied step as the only step in the flow.
  2. If necessary, edit the new step.
  3. Click Save to save the changes to your workbook.

To copy a Transformation step processor to a different workbook

You cannot copy text from the Expert Flow dialog box using Internet Explorer. You must use Mozilla Firefox or Google Chrome for this procedure.

  1. In the source workbook, right-click in the flow and select View Expert Flow.
    The Expert Flow dialog box opens.
  2. In the Expert Flow dialog box, drag to select the Transformation step with the processors you want to copy.
  3. Press Ctrl-C to copy the selected text to your clipboard.
  4. Click OK to close the Expert Flow dialog box.
  5. Paste the highlighted text to a text editor.
    The Active column shows whether each processor is active. The Expression column shows the expression text for each processor.
  6. Copy the Expression text you want to reuse in a different workbook. Do not copy the Active part of the row.
  7. In the destination workbook, right-click in the flow and select New Processor.
    The Edit Processor dialog box opens.
  8. In the expression area, paste the Expression text you copied.
    The Edit Processor window is updated to match the type and expression of the source processor.
  9. Edit the new processor as needed, and then click OK.
  10. Repeat steps 6 through 9 for each processor you want to copy from the source Transformation step.
  11. Click Save to save the changes to your destination workbook.
Last modified


This page has no custom tags.


This page has no classifications.

 (c) Copyright 2017-2020 Hewlett Packard Enterprise Development LP