Skip to main content

Varicent ELT Assistant

US population

Use the US population tool to join the US population data on the county or state to your data.

Configuration

Use the following configuration options to help configure the US population tool.

Configuring the US population tool

  1. Go to the Pipes module from the side navigation bar.

  2. From the Pipes tab, click an existing pipe to open, or create a new pipe. To create a new pipe, read the Creating a pipe documentation.

  3. In the Pipe builder, add a data source to your pipe. For more information on adding a data source, see the Data Input tool.Data Input

  4. Click symon_add_icon.png + Tool.

    The Tools modal opens, where you can add tools, such as the  Aggregate  tool, to your pipe.

  5. In the Tools modal search bar, type US population, and then click + Add Tool.

    Tip

    You can also find the US population tool in the Data section.

  6. Click the tool node and drag the line to the next tool to connect the tools. If you need to undo the action, click the line and then click Unlink.

  7. In the configuration pane, under Year, select the year to use for populating your data set.

  8. Under Age group, select the age group for your data set. Choose from Select all, none, or a variety of ages.

  9. Under Gender, select the gender to use for populating your data set:

    • Select all

    • Select none

    • Male

    • Female

    • Total

  10. Under State/Province column, select the column to use for the State or Province.

  11. Under County, select the colunt to use for the county.

  12. Click on the tool name to rename your tool node to a meaningful name. Name your tools in a way that describes the function, not the object or the data action. For example, use “Look up rate” instead of “Join to rate table”.