Search

Insert Bulk data into Jiffy table

Articles

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

Syntax

Insert Bulk data into a Jiffy table (Jiffy_table_name, Column_name, Values)

Parameters

Input Parameter Name Description
Jiffy_table_name Data Table Variable
Column_name Column Names
Values Values to be inserted in to the table (Table Type 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 a table type variable(SingleColTable)

The table type variable of UUID returned must be assigned to a SingleColsTable variable

Sample

Insert Bulk data into a Jiffy table (Customer, CustomerName, City, Country, Address)

  • Inserts ‘Address’ data into ‘CustomerName’,’ City’,’ Country’ columns in the Customer table and returns UUID of the rows inserted.

To view all the Table functions, click here.

Did you find what you were looking for?