Search

Insert data into a Jiffy Table

Articles

Use this function to insert data into Jiffy table.

Syntax

Insert data into a Jiffy table (Jiffy_table_name, Column_name, Data)

Parameters

Input Parameter Name Description
Jiffy_table_name Data Table Variable
Column_name Column Names
Data Data passed can be either constant or variable where the data is stored

  • The Jiffy table name and Columns names provided must match with the names in the Dataset and are case sensitive.
  • Both data and column names must be comma-separated.
  • Data for each column must be in the same order as the columns.

Returns

Return value Description
UUID Returns UUID of the inserted row

Sample

Insert data into a Jiffy table (Customer, CustomerName, City, Country, Cardinal, Stavanger, Norway)

  • Inserts ‘Cardinal,’ Stavanger’, Norway’ data into ‘CustomerName’,’ City’,’ Country’ columns in the Customer table and returns UUID of the inserted record.

To view all the Table functions, click here.

Did you find what you were looking for?