Search

Insert Bulk data into jiffy table

Articles

Use this function to insert multiple rows into the Jiffy table.

Syntax

Insert Bulk data into jiffy table (Jiffy_table_name, Column_name, Values)

Parameters

Input Parameter Name Description
Jiffy_table_name Name of Jiffy Table
Column_name Column Names
Values Values to be inserted in to the table (DataTable Variable )

  • 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 each row of the inserted data as DataTable variable(SingleColTable)

UUID returned must be assigned to SingleColsTable DataTable Variable.

Sample

Insert Bulk data into jiffy table (Customer, CustomerAddress, Address)

  • Inserts Address DataTable variable into CustomerAddress columns in the Customer table.
    Returns UUID of the rows inserted.

To view all the Table functions, click here.

Did you find what you were looking for?