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