transformations:peek
Table of Contents
PEEK
Category: Transform / Basic
Description
This action takes a value from another table and creates a new column populated with this value.
Use cases
A typical use case for this action would be bringing in a total value from another table for further calculation - such as % from the total.
Action settings
| Setting | Description |
|---|---|
| Peek from table | Select the table the value resides in. |
| From column | Select the column the value resides in. |
| From | Input the row the value resides in. Options: Row #* (select the specific row number the valued resides in) and Last row (pull the value from the last row in the column). |
* Setting can be specified using a parameter.
Examples
Source table A:
| Province | Total Amount |
|---|---|
| All | 4500 |
Source table B: (before transformation)
| Province | Amount |
|---|---|
| Ontario | 1000 |
| British Columbia | 1500 |
| Quebec | 2000 |
Action parameters:
Peek from Source table A
From column Total Amount
Row # 1
Result table (Source table B): (after transformation)
| Province | Amount | Total Amount |
|---|---|---|
| Ontario | 1000 | 4500 |
| British Columbia | 1500 | 4500 |
| Quebec | 2000 | 4500 |
Community examples
- Process a group of files only when all of them are present (Project; Module: Main; Group: Tab 1; Table: Table 1; Action position: 2)
- How to pull data from web APIs with pagination (Project; Module: Query API; Group: Group 1; Table: Query; Action position: 5)
- Ideas for generating random password strings? (Project; Module: Main; Group: Group 1; Table: Generator; Action position: 2)
See also
transformations/peek.txt · Last modified: 2021/07/19 01:48 by craigt