Skip to main content

Optimize your data in Dataflow

Modify your data in Dataflow in Productsup.

Introduction

You can modify your data in Data View or Dataflow before exporting it. The difference between editing your data in Data View and Dataflow is as follows:

  • Data View lets you see the actual data and preview the results of the changes you make with rule boxes. See Add a rule box to learn how to add rule boxes in Data View.

  • Dataflow provides a broad overview of all the connections and rule boxes you have already applied. You can add rule boxes, append one attribute's column to another, replace connections, and copy and apply rule boxes to other attributes. This document describes all these features.

Add a rule box in Dataflow

  1. Go to Dataflow from your site's main menu and select a needed export from the drop-down menu on the left side of the top ribbon.

  2. Select an attribute in the column where you are adding a rule box. The panel on the right opens.

  3. Select the Select an Option drop-down menu, search for and select the needed rule box in the list.

    Select an option
  4. Configure the rule box by selecting or entering values.

    Tip

    Select the wrench icon 🔧 in the top-right corner of the rule box to open advanced options such as pausing, duplicating, removing, or applying the rule box to a segment.

  5. Select Save.

  6. Go to Data View from your site's main menu, select the same export as in Dataflow where you added the rule box, and see the changes in the attribute.

Add a rule box in Dataflow using Large View

To see a list of the available rule boxes and filter them, use Large View:

  1. In the right panel opened after you selected an attribute for editing, select the Large View button.

    Large View in DF
  2. Select All rule boxes to choose a needed rule box category, select if you want to sort the rule boxes alphabetically or by popularity, or search for the needed rule box by its name in Filter.

    Search a rule box by category, sort or filter
  3. Drag the rule box to the needed stage: the green area is for import to intermediate stages, and the blue area is for intermediate to export stages.

    Rule boxes stages
  4. Configure the rule box and select Save.

Edit a rule box in Dataflow

You can edit any rule box after you have applied it.

  1. Go to Dataflow from your site's main menu and select a needed export from the drop-down menu on the left side of the top ribbon.

  2. Select an attribute in the stage where you added a rule box. The panel on the right opens.

  3. Configure the rule box by selecting or entering values.

  4. Select Save.

View all applied rule boxes in Dataflow

In Dataflow, you can see bubbles of different colors on connections between the stages. Each bubble represents a rule box that you applied to an attribute. Here are the meanings of the colors:

  • Green bubbles are rule boxes between the Import and Intermediate stages.

  • Blue bubbles are rule boxes between the Intermediate and Export stages.

  • Gray bubbles are rule boxes on pause.

  • Yellow bubbles are rule boxes containing skip rules.

To get more information about the applied rule boxes:

  1. Hover over a connection to see a list of all rule boxes applied to it.

    Hover over the connection to see rule boxes
  2. Select the needed attribute to see the rule box settings in detail. Or select the arrow icon that appears when hovering over to open Large View.

Filter rule boxes in Dataflow

Filter rule boxes in Dataflow to find the necessary rule box applied to a connection. The platform hides all other rule boxes, leaving only those matching your search term.

  1. Go to Dataflow from your site's main menu.

  2. In the upper ribbon, enter a rule box name in Filter Boxes.

    Filter rule boxes

Append data from one attribute to another

You can append data from one attribute to another in Dataflow. For example, you can append values from the color and size attributes to your title attribute.

Tip

Alternatively, you can do it with the Append/Prepend Column rule box. See Append or prepend the data from another column.

To append data of one attribute to another using the Dataflow connections:

  1. Go to Dataflow from your site's main menu.

  2. Select the needed export from the drop-down menu on the left side of the upper ribbon.

    channel drop-down
  3. Choose an attribute you want to append and map it to the desired attribute in the next stage. The attribute in the next stage should already have a connection to another attribute.

    For example, you want the id attribute to display the product name after the id. You can append data from product name in the intermediate stage to id in the export that has a connection to id in the intermediate stage.

  4. Select Append in the pop-up window.

    Append data from one attribute to another

After appending the attributes, a light-blue connection appears between the attributes in two stages.

Replace a connection between attributes

If you need to change the connection between attributes, you can delete the existing connection and map a new one. But you can also replace a connection between attributes without deleting a previous connection first.

  1. Go to Dataflow from your site's main menu.

  2. Select the needed export from the drop-down menu on the left side of the upper ribbon.

  3. Drag a connection from an attribute to the attribute that already has a connection in the next stage.

  4. Select Replace in the pop-up window.

Prepend attribute

Copy rule boxes from one attribute to another

If you want an attribute to use the same rule boxes as another one, you can copy and reuse these rule boxes.

  1. Go to Dataflow from your site's main menu.

  2. Select the needed export from the drop-down menu on the left side of the upper ribbon.

  3. Select the node of the source attribute containing the rule boxes you want to copy.

    Note

    An orange circle appears on the attribute's node. The node has to be either in the intermediate or export stage.

  4. Select the node of the target attribute in the same stage where you want to copy the rule boxes.

    Note

    The target attribute shouldn't have rule boxes applied. A white circle on the attribute indicates that you can apply these rule boxes to the attribute.

  5. Select Copy in the pop-up window.

    Copy rule boxes