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.

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

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

Table A:

Province	Total Amount
All	4500

Table B: (before transformation)

Transformation parameters:

Peek from Table A
From column Total Amount
Row # 1

Table B: (after transformation)