Talend Exchange is the place where Talend community can share items related to Talend opensource products, such as Data Integration, Data Quality and Data Master Management. Contribution is open to any user, no specific validation is needed. As soon as you have your forum account, you automatically get a Talend Exchange account.


Show

Category
Search
Version
Author
 

Statistics

  • 609 extensions
  • 918 revisions
  • 296 contributors
  • 157375 downloads
 

Top Contributors

Version Author Released on Rating Downloads
Component

tFileExcelSheetOutput

6.4 jlolling 2014-07-14
153

This component depends on tFileExcelWorkbookOpen (contains the library and opens/creates the workbook) and tFileExcelWorkbookSave (saves the workbook as file).
It can create/fill sheets on a very flexible way:
It can set the header with self defined content
It can write columns with gaps
It can copy styles, conditional styles, row height
It can reconfigure written tables to update pivot tables
Please take a look in the documentation linked here. This component is very powerful while using excel templates.

Component

tPLotChart

0.1 bennatigiuliano 2014-07-11
10

This component allows you to generate Plot Graph.

Component

tUnpivotRow

1 wzawwin 2014-07-09
81

tGoogleGeocoder

0.6 llaen 2014-07-07
301

This component takes an address from the input flow and appends lat and lon columns to the output flow for the address. Google\\\\\\\\\\\\\\\'s geocode API is used to look up the latitude and longitude for the address.

Started with the original tGoogleGeocoder component but rewritten for API v3.
It also supports business API (given a client and private key strings).

Instructions:
The input row must have at least one column that contains an address. Select that column in the components \\\\\\\"Address Column\\\\\\\" variable.
The output is the same as the input but with two new columns added (lat and lon) which will contain the latitude and longitude coordinates that Google gave for the input address.

Component

tFileExcelSheetCellOutput

6.3 jlolling 2014-07-03
49

This component writes into referenced cells in a sheet.
It depends on the component tFileExcelWorkbookOpen and tFileExcelWorkbookSave.
The component takes the cell reference and the values / comments from an input flow (simplest way is using a tFixedFlowInput if the reference are fix.

Component

tCalendar

1.1 jlolling 2014-07-01
53

Data warehouses needs a date dimension and this component creates the most of the needed data (also fully localised).
The schema of this component is fully commented.
The main features are:
* creates all possible date categories like day, week, month, year, quarter
* builds integer id for all categories to support a table as dimension
* supports different years (year for the current week and a financial year)
* build automatically a configurable amount of days in the future.

Component

tFileInputTextFlat

3.2 jlolling 2014-06-30
47

This component is dedicated to read text files.
Advantages:
* reads fields with gaps between them
* can configure the columns by the header line (also with regex)
* reduced byte code foodprint
* can apply regex expressions to the field content
* translates the numbers for any country formats

Component

tLOBDownload

1.0 jlolling 2014-06-30
19

This component downloads a LOB (BLOB or CLOB) object.
For CLOB content you can set a charset because the CLOBs like BLOBs are always byte streams.

Component

tFileExcelSheetList

6.3 jlolling 2014-06-30
75

This component iterates through the sheets of a excel workbook.
It depends on the component tFileExcelWorkbookOpen.
The sheets can be retrieved within an iteration as well as in a flow.

Component

tJsonNormalize

1.3 jlolling 2014-06-29
59

It normalizes JSON objects (received as text column or from a MongoDB).
The component goes recursive through the JSON object and returns all simple values (also in arrays) with the value, and the path the the attribute.

Show

Category
Search
Version
Author
 

Statistics

  • 143 extensions
  • 207 revisions
  • 38 contributors
  • 17816 downloads
 

Top Contributors

Version Author Released on Rating Downloads
Regex

Temperature in Celsius

1.0 scorreia 2014-08-18
9

Check that a given number is a valid temperature in Celsius.

Regex

Companies House

4.0 mhallam 2014-07-29
69

This Regular Expression is used to match the Companies House 503 Reference number that is given when a customer places an online order.www.companieshouse.gov.uk

Regex

Bulgaria Vat Number

4.0 mhallam 2014-07-29
58

Vat number for Bulgaria. Formats are
BG123456789
BG1234567890

Regex

Austria VAT Number

4.0 mhallam 2014-07-29
74

mysql

Regex

Complex Australian Phone Number

4.0 mhallam 2014-07-29
75

Australian phone number validator. Accepts all forms of Australian phone numbers in different formats (area code in brackets, no area code, spaces between 2-3 and 6-7th digits, +61 international dialing code). Checks that area codes are valid (when entered).

Regex

Bank Routing Transit Number (RTN)

4.0 mhallam 2014-07-29
69

Ensures a given string matches the basic pattern of a bank routing transit number (RTN), used to identify financial institutions on instruments such as checks. Ensures number is nine digits long and has first two digits that comply with American Bankers Association rules.

Regex

ISBN Checker

4.0 mhallam 2014-07-29
90

Expression to check for a valid ISBN number

Regex

International Passport

4.0 mhallam 2014-07-29
66

? 9 characters made up of a combination of numbers and/or letters. Where less than 9 characters it will be padded out to the right with chevrons (

Regex

UK Vehicle Registration Plate Number Plate

4.0 mhallam 2014-07-29
91

AB12 RCY|||CD07 TES|||S33 GTT|||Y999 FVBab12 rcy|||CD07 TIS|||S34 GTT|||Z999 FVB

UK Vehicle Registration Plate / Number Plate format as specified by the DVLA. Accepts both "Prefix" and "New" style. Allows only valid DVLA number combinations as not all are supported. Registration number must be exactly as is displayed on car, hence all letters must be in uppercase and a space seperating the two sets of characters.

Regex

Swedish Personal Nr (Personnummer)

4.0 mhallam 2014-07-29
101

Simple regex for the Swedish personal number. It's in the form: YYMMDD-xxxx where xxxx is an arbitrary number from 0000-9999.

791231-1234

Show

Category
Search
Version
Author
 

Statistics

  • 5 extensions
  • 7 revisions
  • 4 contributors
  • 4042 downloads
 

Top Contributors

Version Author Released on Rating Downloads
Export

Product Demo

3.0 ctoum 2012-05-31
624

Product & families, with Cafepress pictures.

Data-Model

Clinical Trials: Janus Model Basics

1.0 jaymce 2010-11-22
407

This is a model of the basic of the Janus Clinical Data Repository.
http://www.fda.gov/ForIndustry/DataStandards/StudyDataStandards/ucm155327.htm

Data-Model

D* Demo Model

1.0 ctoum 2010-08-13
747

Model used in the D* Demo.

Export

Talendshop Demo

1.0 ctoum 2010-08-04
1132

Talendshop Demo (Demo Project)


97 ms