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 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

Table A:

Province Total Amount
All 4500

Table B: (before transformation)

Province Amount
Ontario 1000
British Columbia 1500
Quebec 2000

Action parameters:

Peek from Table A
From column Total Amount
Row # 1

Table B: (after transformation)

Province Amount Total Amount
Ontario 1000 4500
British Columbia 1500 4500
Quebec 2000 4500


See also

transformations/peek.txt · Last modified: 2021/03/29 01:25 by craigt