Select data from Jiffy table
Last Updated: Dec 2, 2020
Last Updated: Dec 2, 2020
Use this function to extract data from Jiffy table.
Select data from Jiffy table (Jiffy_table_name, Column_name, Offset, Count)
| Input Parameter Name | Description |
|---|---|
| Jiffy_table_name | Data Table Variable |
| Column_name | Column Name to be extracted and the Condition to filter the output of the function separated by a comma |
| Offset | Row Number to start select from |
| Count | Total number of records to be extracted from the result set |
| Return value | Description |
|---|---|
| Records | Returns the table of records |
Select data from Jiffy table(Branches, BranchName, BranchName=’NY’, 5, 10)
To view all the Table functions, click here.