Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Python Programs
    • Java Programs
    • SQL FAQ’s

Talend Sample Row

by suresh

The Talend Sample Row or tSampleRow takes an input, selects the range of rows from it, and returns an output.

In this Talend Sample Row example, we are using the DimCurrency table available in the SQL AdventureWorks DW database.

Talend Sample Row Example 1

Talend Sample Row Example

First, we established a connection to SQL Server. Next, used the DBInput to select the DimCurrency table within a database.

Talend Sample Row Example 2

Drag and drop the sample row field from palatte to job design window.

Talend Sample Row Example 3

Within the Talend tSampleRow Component tab, you can see the Range with examples. Let me explain those examples.

  • “1, 5” – It returns lines 1 and 5 from the input (DimCurrency table).
  • “10..20” – It only returns records or rows from line 10 to 20.
  • “23..45, 48, 50..54” – It returns records from 23 to 45, 48th record, and rows from 50 to 54.

The Talend Sample row has an example range value “1, 5, 10..20”. It means the tSampleRow will select 1st row, 5th row, and rows from 10 to 20. For now, we leave these default range values.

Talend Sample Row Example 4

Before we perform any action, let me show you the Schema by clicking the Edit Schema button. Change the records as per your need, and for me no need to change anything.

Talend Sample Row Example 5

Next, drag-and-drop the DBOutput field and use the existing connection. As you can see, we are using Talend_SampleRow table as the destination. This Talend Sample row job will create the table if it doesn’t exist. Otherwise, it will drop the existing and creates a new table.

Talend Sample Row Example 6

Let us run the Talend tSampleRow job.

Talend Sample Row Example 7

Let me open Management Studio. From the below query, you can see the records 1, 5, and from 10 to 20.

Talend Sample Row Example 8

For the demonstration purpose, we changed the default range value as “4..8, 15, 25, 50, 75, 90..93, 102..105”. It means rows from 4 to 8, line 15, line 25, line 50, line 75, lines from 90 to 93, and records from 102 to 105.

Talend Sample Row Example 9

You can check the same from the below image.

Talend Sample Row Example 10

Placed Under: Talend

  • Talend Download and Install
  • Create a Talend Business Model
  • Create a Talend Job
  • Create a Global Context Group
  • Connect Talend to SQL Server
  • Context Group to connect DB
  • Talend Read Text File
  • Talend Read Excel File
  • Load Text File Data into Database
  • Load Excel Data into Database
  • Export Database Table to Excel
  • Export Database Table to TextFile
  • Export Database Table to XML
  • Export Database Table to JSON
  • Talend Aggregate Row
  • Talend Aggregate Sorted Row
  • Talend Buffer Input & Output
  • Talend Create Table
  • Talend tDenormalize
  • Talend Datatype Conversion
  • Talend tMap Type Conversion
  • Talend Filter Columns
  • Talend Filter Rows
  • Talend tMap filter rows
  • Talend tFileList
  • Talend tFixedFlowInput
  • Talend tForeach
  • Talend Fuzzy Matching
  • Talend Joins
  • Talend tMap Joins
  • Talend tMap Join Lookup
  • Talend tJava
  • Talend tJavaRow
  • Talend tJavaFlex
  • Talend tLoop
  • Talend tMsgBox
  • Talend tNormalize
  • Talend Pivot Columns
  • Talend Replace Data
  • Talend Replicate
  • Talend tRowGenerator
  • Talend tRunJob
  • Talend Rejected Rows
  • Talend Sample Row
  • Talend Sort Row Data
  • Talend SCD
  • Talend SCD Type 2 Manual
  • Talend Unite
  • Talend Unique Row
  • Talend Read Multi-Structure File
  • Talend Parent Child Job
  • Talend Execute SQL Queries
  • C Tutorial
  • C# Tutorial
  • Java Tutorial
  • JavaScript Tutorial
  • Python Tutorial
  • MySQL Tutorial
  • SQL Server Tutorial
  • R Tutorial
  • Power BI Tutorial
  • Tableau Tutorial
  • SSIS Tutorial
  • SSRS Tutorial
  • Informatica Tutorial
  • Talend Tutorial
  • C Programs
  • C++ Programs
  • Java Programs
  • Python Programs
  • MDX Tutorial
  • SSAS Tutorial
  • QlikView Tutorial

Copyright © 2021 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy