This is an old revision of the document!

PEEK

Category: Transform / Basic

Description

This action takes a value from another table and creates a new column populated with this value.

A typical use case for this action would be bringing in a total value from another table for further calculation - such as % from total.

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.

Table A:

Province	Total Amount
All	4500

Table B: (before transformation)

Action parameters:

Peek from Table A
From column Total Amount
Row # 1

Table B: (after transformation)