Data from Table with partitioning

Goal: Setup a workbook formula that pulls the data from the database (use the given connection string), partition the data by "PIN" with 3 maximum data per partition and sort the result by "S_No." in ascending form.

Connection String: Data Source=(local)\SQLEXPRESS;Integrated Security=True;User ID=SheetKraft;Initial Catalog=testdb1
Table Name: "dbo"."dummy"


  1. Use the UI DataFromDatabase.SK, connect to the relevant datasource using above given connection string.
  2. Select the Table radio button and and then search for the given table by clicking on TableName [horizontal dotted button].
  3. Enter the Max rows and select the "in Partition" and then select the desired column for "Partition by" and "Sort by".