DataFrame

NodeOutputDataFrame provides utility methods for interacting with a dataframe of a previous node.

Methods

row(index: Integer)

Description: Read the row at the given index from the node's dataframe output. Example: row(1) or row(10).

Parameters:

• index (type: Integer): The row number (starting for 0).

Example: Search for columns in the row with the help of the autocomplete.

VisualQuery_1.row(3).name

---

totalRows(): Integer

Description: Get the total number of rows in the dataframe.

Returns: An Integer representing the number of rows

VisualQuery_1.totalRows()

---

asJson(page: Integer, limit: Integer): JsonNode

Description: Get the data of the table as a json rows.

Parameters:

• page (type: Integer): The page number (starting for 1).

• limit (type: Integer): The maximum number of rows.

Returns: A JSON of the selected part in the dataframe

VisualQuery_1.asJson(1, 10);

---

asText(page: Integer, limit: Integer): String

Description: Get the data of the table as a textrows.

Parameters:

• page (type: Integer): The page number (starting for 1).

• limit (type: Integer): The maximum number of rows.

Returns: A String of the selected part in the dataframe

VisualQuery_1.asText(1, 10);