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 Name of Jiffy Table
Column_name Column Name
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 Jiffy Table (CustomerDetails, Name,Country, John Smith,Norway)

  • Inserts the data “John Smith” and “Norway” under the Name and Country column of the CustomerDetails table respectively. Returns the UUID of inserted row.

To view all the Table functions, click here.

Did you find what you were looking for?