Designer Cloud Tools

DateTimeNow ToolDateTimeNow Tool

Use DateTimeNow to input the current date and time at workflow runtime in the format you choose.

Directory Tool

Use the Directory tool to return a list of files from a cloud storage location along with file details.

Input Data ToolInput Data Tool

Use Input Data to connect to a table to pull data into your workflow.

Output Data ToolOutput Data Tool

Use Output Data to write results of a workflow to supported file types or data sources.

Text Input ToolText Input Tool

Use Text Input to manually enter text to create small data files for input. This can be useful in testing and creating Lookup tables while you build your workflow.

Auto Column Tool

Use Auto Column to automatically change the column type and size for efficient storage of string data.

Create Samples ToolCreate Samples Tool

Use Create Sample to split the input records into 2 or 3 random samples.

Data Cleanse Pro Tool

Use Data Cleanse Pro to fix common data quality issues. You can replace null values, remove punctuation and HTML tags, modify capitalization, and more.

Data Cleansing ToolData Cleansing Tool

Use Data Cleansing to fix common data quality issues. You can replace null values, remove punctuation, modify capitalization, and more.

Filter ToolFilter Tool

Use Filter to select data using a condition.

Formula ToolFormula Tool

Use Formula to create new columns, update columns, and use 1 or more expressions to perform a variety of calculations and operations.

Generate Rows Tool

Use Generate Rows to create new rows of data with an expression.

Imputation ToolImputation Tool

Use Imputation to clean up missing values in your data.

Multi-Column Binning ToolMulti-Column Binning Tool

Use Multi-Column Binning to tile or bin on multiple columns.

Multi-Column Formula ToolMulti-Column Formula Tool

Use Multi-Column Formula to create or update multiple columns using a single expression.

Multi-Row Formula Tool

Use Multi-Row Formula to create and update columns by using row data to create formulas.

Oversample Column ToolOversample Column Tool

Use Oversample Column to automatically create balanced samples from imbalanced data for use in statistical modeling.

Random % Sample ToolRandom % Sample Tool

Use Random % Sample to return an expected number of rows that result in a random sample of the incoming data stream.

Rank Tool

Use Rank to rank your data for further processing or output.

Row ID ToolRow ID Tool

Use Row ID to create a new column in the data and assign a unique identifier, which increments sequentially for each row in the data.

Sample ToolSample Tool

Use Sample to limit the data stream to a specified number, percentage, or random set of rows. In addition, the Sample tool applies the selected configuration to the columns you want to group by.

Select ToolSelect Tool

Use Select to include, exclude, and reorder the columns of data that pass through your workflow.

Select Rows ToolSelect Rows Tool

Use Select Rows to return rows and ranges of rows that are specified, including discontinuous ranges of rows. This tool is useful for troubleshooting and sampling.

Sort ToolSort Tool

Use Sort to arrange the rows in a table in alphanumeric order based on the values of the specified data fields.

Tile ToolTile Tool

Use Tile to assign a value (tile) based on ranges in the data. The tool does this based on the user specifying 1 of 3 methods.

Unique ToolUnique Tool

Use Unique to distinguish whether a row is unique or a duplicate by grouping on one or more specified columns, then sorting on those columns.

Append Columns ToolAppend Columns Tool

Use Append Columns to append every row from a source dataset to every row of a target dataset. This operation is also known as a cross join.

Find Replace ToolFind Replace Tool

Use Find Replace to find a string in 1 column of a dataset and look up and replace it with another string. You can also use Find Replace to append columns to a row.

Fuzzy Match Tool

Use Fuzzy Match to identify non-identical duplicates of a dataset.

Join ToolJoin Tool

Use Join to combine 2 inputs based on common columns between the 2 tables. You can also join 2 data streams based on row position.

Join Multiple ToolJoin Multiple Tool

Use Join Multiple to combine 2 or more inputs based on a commonality between the input tables. By default, the tool outputs a full outer join.

Make Group Tool

Use Make Group to take data relationships and assemble the data into groups based on those relationships.

Union ToolUnion Tool

Use Union to combine 2 or more datasets on column names or positions.

DateTime ToolDateTime Tool

Use DateTime to transform date-time data to and from a variety of formats, including both expression-friendly and human-readable formats.

RegEx ToolRegEx Tool

Use RegEx to use regular-expression syntax to parse, match, or replace data.

Text to Columns ToolText to Columns Tool

Use Text To Columns to take the text in 1 column and split the string value into multiple separate columns or rows, based on a 1 or more delimiters.

XML Parse Tool

Use XML Parse to parse XML into columns.

Arrange Tool Arrange Tool

Use Arrange to manually transpose and rearrange your columns for presentation purposes. Data is transformed so that each row is turned into multiple rows, and you can create new columns using column description data.

Count Rows Tool Count Rows Tool

Use Count Rows to return a count of the number of rows passing through the tool. Use this tool when you want to report on the resulting row count of a process. It even returns a count of zero which a Summarize tool does not do.

Cross Tab Tool Cross Tab Tool

Use Cross Tab to pivot the orientation of data in a table by moving vertical columns onto a horizontal axis and summarizing data where specified.

Make Columns Tool

Use the Make Columns tool to take rows of data and arrange them by wrapping records into multiple columns.

Rolling Window Tool

Enables dynamic, sliding-window style aggregations—ideal for time-series, performance monitoring, and any analysis requiring context over sequential rows of data.

Running Total Tool Running Total Tool

Use Running Total to calculate a cumulative sum per row in a dataset.

Summarize Tool Summarize Tool

Use Summarize to perform various actions (functions and calculations) on your data.

Transpose Tool Transpose Tool

Use Transpose to pivot the orientation of a data table.

Weighted Average Tool Weighted Average Tool

Use Weighted Average to calculate the weighted average of an incoming data column.