Create Index Operator: Numbering Rows

Overview

There are many ways to use the Create Index operator. You can use it to add new rows of information to an existing Data Table. Or, you can use it to filter out a specific row of data. You can also use it to number each row of a Data Table. Let's say you have a table of patients, and you want to assign each of them a number. Maybe this is a chart number for organizing your patient records. You can use the Create Index operator to assign those chart numbers.

Here's how your module will look in the Module Builder:

Here's how the completed use case will look in Express View, including a peek at the DevTools Console:

What You'll Learn

In this article, you'll learn how to use the Create Index operator to number table rows.

What You'll Need

To set up this use case, you’ll need:

• 1 Data Table component

• 1 Initializer component

• 2 Hidden components

• 1 ViewGrid component

• 1 Data Workflow component

To set up your Data Workflow, you'll need:

• 1 Input operator

• 1 Create Index operator

• 1 Output operator

• 1 Console operator

These instructions assume you have a new module open, saved, and with a title.

Configuration

Configure the Data Table Component

First, you'll set up a Data Table with a list of patient names, dates of birth, and their insurance status.

1. In the Module Builder, drag and drop a Data Table component onto your canvas, placing it inside your Panel.

2. Enter dtPatients in the Label and Property Name fields.

3. In the data table, enter the following:

   firstName	lastName	dob	insurance
   Art	Venere	11/11/1988	Yes
   Alisha	Slusarski	6/30/1974	No
   Blair	Malet	12/22/2000	Yes
   Willow	Kusko	5/27/1984	No
   Meaghan	Garufi	4/13/1994	Yes
   Abel	Maclead	2/18/1965	Yes
   Willow	Kusko	5/27/1984	No
   Ernie	Stenseth	6/1/1966	Yes
   Jose	Stockham	11/11/1988	Yes

   You've intentionally added duplicate information for further Create Index use cases.

   

4. Click Save.

Configure the Initializer Component

Now, you'll set up an Initializer component to trigger your Data Workflow. You'll add your Data Workflow soon.

1. Drag and drop an Initializer component onto your canvas, placing it below your Data Table.

2. Enter initPatients in the Property ID and Canvas Label Text fields.

3. Set the Trigger Type as New Submission.

4. In the Outputs table, set the following:

   1. Property ID: enter dwfPatients.

   2. Type: enter trigger.

   3. Value: enter GO.

   

5. Click Save.

Configure the Hidden Components

In the first Hidden component, you'll store your Data Workflow's output. In the second, you'll store the index data. That way, you can display stored data and your new data in the same dashboard.

1. Drag and drop 2 Hidden components onto your canvas, placing one after the other below your Initializer.

2. Enter the Property ID and Canvas Label Text as follows:

   Property ID	Canvas Label Text
   patients	patients
   vgIndex	vgIndex

3. Set Store Data in Database toggle to ON.

4. Save each component as you add it.

Configure the ViewGrid Component

Next, let's bring in a ViewGrid component so your end-user can see the patient information.

1. Drag and drop a ViewGrid component onto the canvas, placing it below your Data Table.

2. Enter Patients in the Label field.

3. Enter gridPatients in the Property Name field.

4. Enter null in the Action field.

5. Enter patients in the ID column of the Inputs table.

6. In the Outputs table, enter the following:

   1. ID: enter vgIndex.

   2. Mapping: enter index.

7. In the Display table, enter the following:

   ID	Formula	Heading
   patientIndex		Chart Number
   firstName		First Name
   lastName		Last Name
   dob		Date of Birth
   insurance		Insurance?

   

8. Click Save.

Configure the Data Workflow Component

Now, you'll set up your Data Workflow. All you're really doing here is having the Create Index operator add a number to each row of your table. Instead of starting your list with the default [0], let's start with [1]. That means you'll use [1] for your starting index and number your table from top to bottom. You'll also add a Console operator so you can see your results.

1. Drag and drop a Data Workflow component onto your canvas. Place your Data Workflow below your ViewGrid component.

2. Enter dwfPatients in the Canvas Label Text and Property Name fields.

   

Configure the First Input Operator

1. Drag and drop an Input operator onto your Data Workflow canvas.

2. Configure the Input operator's Info window as follows:

   Setting	Value
   Category	Input
   Component	dtPatients
   Required	No
   Source	Default

Configure the Create Index Operator

1. Drag and drop a Create Index operator onto your Data Workflow canvas.

2. Configure the Create Index operator's Info window as follows:

   Setting	Value
   Category	Create Index
   Label	Patients
   Index Name	patientIndex
   Starting Index	1
   Keys

3. Connect the output port (right) of the Input operator to the input port (left) of the Create Index operator.

Configure the Output Operator

1. Drag and drop an Output operator onto your Data Workflow canvas.

2. Configure the Output operator's Info window as follows:

   Setting	Value
   Category	Output
   Component	patients
   Action	value

3. Connect the output port (right) of the Create Index operator to the input port (left) of the Output operator.

Configure the Console Operator

1. Drag and drop a Console operator onto your Data Workflow canvas.

2. Configure the Console operator's Info window as follows:

   Setting	Value
   Category	Console
   Label	Indexed Patients

3. Connect the output port (right) of the Create Index operator to the input port (left) of the Console operator.

4. Click Save.

5. Save your module.

Now you can test out your Data Workflow. Open up the DevTools Console, and you'll see patient information from your Data Table. You'll see the numbers you added in the DevTools Console, as well as in the left column of your table.

Lab

You can view this complete use case here: https://training.unqork.io/#/form/603fb05c72ef640243f19684/edit.