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

Append Total amount to each row in Table 2

Table 1: Total amount value

Province	Total Amount
All	4500

Table 2: Provincial expenses

Peek from Source table A
From column Total Amount
Row # 1

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)