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.


Version Author Released on Rating Downloads
Component

tFileExcelSheetOutput

6.3.1 jlolling 2014-07-13
26

This component depends on tFileExcelWorkbookOpen.
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
2

This component allows you to generate Plot Graph.

Component

tUnpivotRow

1 wzawwin 2014-07-09
11

tGoogleGeocoder

0.6 llaen 2014-07-07
265

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
11

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
27

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

tDB2TemoralMergeELT

1.8 jlolling 2014-07-01
8

This component is an ELT usage of the DB2 temporal tables, introduced with the release 10.1 of the IBM DB2 database.
Temporal tables are a native Slowly Changing Dimension Type 2 implementation (with bi-temporal means you have a business time period and a system time period for the validity of your data).
This component create and run all necessary statement to:
create tables (actual data and history data)
create indices
merge or the date from the source table (insert, update and delete)
managing the versioning

Component

tFileInputTextFlat

3.2 jlolling 2014-06-30
14

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
10

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
31

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.

Average Length With Blank For SQL Server Storing Large


  • Author: yyi
  • Categories: Indicator
  • First revision date: 2012-06-12
  • Latest revision date: 2012-06-12
  • Compatible with: Data Quality releases 5.0.0, 5.0.0M1, 5.0.0M2, 5.0.0M3, 5.0.0M4, 5.0.0M5, 5.0.0RC1, 5.0.0RC2, 5.0.0RC3, 5.0.1, 5.0.2, 5.1.0, 5.1.0M2, 5.1.0RC1, 5.1.1
  • Downloads: 23

About: Computes the average length of the field, counting blank data as zero length values, the text filed type should be ntext or text in Microsoft SQL Server.

Revision list

expand/collapse all

Revision 1.0 23 Downloads, Released on 2012-06-12
Download revision 1.0

Compatible with: 5.1.1, 5.1.0, 5.1.0RC1, 5.1.0M2, 5.0.2, 5.0.1, 5.0.0, 5.0.0RC3, 5.0.0RC2, 5.0.0RC1, 5.0.0M5, 5.0.0M4, 5.0.0M3, 5.0.0M2, 5.0.0M1

Related to http://jira.talendforge.org/browse/TDQ-5030

Reviews (0)

Be the first to review this extension!

 

Submit review
Name:*
Email:*
Title:*
Please select your rating*
Review:*


Version Author Released on Rating Downloads
Export

Product Demo

3.0 ctoum 2012-05-31
591

Product & families, with Cafepress pictures.

Data-Model

Clinical Trials: Janus Model Basics

1.0 jaymce 2010-11-22
398

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
733

Model used in the D* Demo.

Export

Talendshop Demo

1.0 ctoum 2010-08-04
1125

Talendshop Demo (Demo Project)


82 ms