Basic Prep and Blend
The Basic Prep and Blend capability provides access to basic prep and blend tools via Designer Cloud or Designer Desktop.
Starter Edition
Access to Designer Cloud only.
Access to basic prep and blend tools from the Standard tool palette, listed below.
Access via Full User role only.
Professional and Enterprise Editions
The Basic User role has access to basic prep and blend tools via either Designer Desktop or Designer Cloud.
The Full User role has access to the following basic prep and blend tools.
Tool Category | Tool | Designer Desktop | Designer Cloud |
|---|---|---|---|
Developer | Block Until Done (Designer Desktop) | ✓ | N/A |
Dynamic Input (Designer Desktop) | ✓ | N/A | |
Dynamic Rename (Designer Desktop) Dynamic Rename (Designer Cloud) | ✓ | ✓ | |
Message (Designer Desktop) | ✓ | N/A | |
Control Container (Designer Desktop) | ✓ | N/A | |
Documentation | Comment (Designer Desktop) | ✓ | ✓ |
Tool Container (Designer Desktop) | ✓ | ✓ | |
In/Out | Text Input (Designer Desktop) Text Input (Designer Cloud) | ✓ | ✓ |
Browse (Designer Desktop) | ✓ | N/A | |
Input Data (Designer Desktop) Input Data (Designer Cloud) | ✓ | ✓ | |
Output Data (Designer Desktop) Output Data (Designer Cloud) | ✓ | ✓ | |
Directory (Designer Desktop) | ✓ | N/A | |
Join | Append Fields (Designer Desktop) Append Columns (Designer Cloud) | ✓ | ✓ |
Find Replace (Designer Desktop) Find Replace (Designer Cloud) | ✓ | ✓ | |
Join (Designer Desktop) Join (Designer Cloud) | ✓ | ✓ | |
Union (Designer Desktop) Union (Designer Cloud) | ✓ | ✓ | |
Join Multiple (Designer Desktop) Join Multiple (Designer Cloud) | ✓ | ✓ | |
Parse | RegEx (Designer Desktop) RegEx (Designer Cloud) | ✓ | ✓ |
DateTime (Designer Desktop) DateTime (Designer Cloud) | ✓ | ✓ | |
Text to Columns (Designer Desktop) Text to Columns (Designer Cloud) | ✓ | ✓ | |
Preparation | Generate Rows (Designer Desktop) Generate Rows (Designer Cloud) | ✓ | ✓ |
Multi-Field Formula (Designer Desktop) Multi-Column Formula (Designer Cloud) | ✓ | ✓ | |
Multi-Row Formula (Designer Desktop) Multi-Row Formula (Designer Cloud) | ✓ | ✓ | |
Unique (Designer Desktop) Unique (Designer Cloud) | ✓ | ✓ | |
Record ID (Designer Desktop) Row ID (Designer Cloud) | ✓ | ✓ | |
Filter (Designer Desktop) Filter (Designer Cloud) | ✓ | ✓ | |
Formula (Designer Desktop) Formula (Designer Cloud) | ✓ | ✓ | |
Sample (Designer Desktop) Sample (Designer Cloud) | ✓ | ✓ | |
Select (Designer Desktop) Select (Designer Cloud) | ✓ | ✓ | |
Sort (Designer Desktop) Sort (Designer Cloud) | ✓ | ✓ | |
Auto Field (Designer Desktop) Auto Column (Designer Cloud) | ✓ | ✓ | |
Data Cleanse Pro (Designer Desktop) | ✓ | N/A | |
Transform | Cross Tab (Designer Desktop) Cross Tab (Designer Cloud) | ✓ | ✓ |
Running Total (Designer Desktop) Running Total (Designer Cloud) | ✓ | ✓ | |
Summarize (Designer Desktop) Summarize (Designer Cloud) | ✓ | ✓ | |
Transpose (Designer Desktop) Transpose (Designer Cloud) | ✓ | ✓ | |
SDK | V1 SDK Tools (Designer Desktop) | ✓ | N/A |
V2 SDK Tools (Designer Desktop) | ✓ | N/A |