User Tools

Site Tools


transformations:peek

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

SettingDescription
Peek from tableSelect the table the value resides in.
From columnSelect the column the value resides in.
FromInput 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


See also

transformations/peek.txt · Last modified: 2021/07/19 01:48 by craigt