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"
- Use the UI DataFromDatabase.SK, connect to the relevant datasource using above given connection string.
- Select the Table radio button and and then search for the given table by clicking on TableName [horizontal dotted button].
- Enter the Max rows and select the "in Partition" and then select the desired column for "Partition by" and "Sort by".