B2Win Suite Documentation (Under Construction)
ContactB2Data
5.6
5.6
  • B2Win Suite Documentation
  • Scripting
    • B2Win Suite Scripting Overview
    • Scripting in B2Data
      • Custom Script Nodes
        • Custom Script
        • Source Script Node (File)
        • Source Script Node (Table)
        • Source Script Node (Object)
        • If-Else Condition
        • Switch case
        • Condition Node
      • In DataPrep
      • Properties
      • Workflow Applications
        • Workflow #1
        • Workflow #2
    • Getting Started
    • Language Basics
    • Types & Objects
      • Primitives
      • Objects
        • Instant
        • LocalDateTime
        • LocalDate
        • LocalTime
        • JsonNode
        • ObjectNode
        • File
        • SuiteTable
        • Duration
        • Period
      • Arrays & Maps
      • Row, Column, StringColumn
    • Contexts
      • Context (Execution)
      • Node Input
        • DataFrame
        • File
        • DataObject
    • Utilities
      • Date & Time
        • InstantUtil
        • GeneralDateUtil
        • LocalDateTimeUtil
        • LocalDateUtil
        • LocalTimeUtil
        • Formatting
        • Timezones
      • Math
      • StrictMath
      • NumericUtil
      • DbUtil
      • DbExecutor
      • DataFrameQueryUtil
      • StateUtil
      • FileUtil
      • JsonUtil
      • HttpUtil
      • NodeInputReader
      • RandomUtil
      • HashingUtil
      • ShellUtil
      • CompressionUtil
      • System
      • Logging
    • Properties
    • Configurations
      • Workflow Configuration
    • Tutorial
    • Feedback
  • B2Data
    • Tutorials
      • Infor DataFabric to On-Premise Database Replication
      • API (DB replication, Email)
    • Workflow Settings
      • General Settings
      • Global/All Properties
      • Execution Configuration
        • General
        • Runtime
        • Compiler
        • Storage
        • Clean Up
      • Permissions
    • Nodes
      • Scheduler
    • Services Configuration
      • Microsoft Graph
Powered by GitBook
On this page

Was this helpful?

  1. Scripting
  2. Contexts
  3. Node Input

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);
PreviousNode InputNextFile

Last updated 18 days ago

Was this helpful?