tFileInputJSON Use Case-Parse JSON using Talend

tFileInputJSON extracts JSON data from a file according to the JSONPath query, then transferring the data to a file, a database table. tFileInputJSON  Use Case : This post I will demonstrate you, how to parse JSON File using Talend.  Below is our sample JSON File. { “Person”: { “firstName”: “John”, “lastName”: “Smith”, “age”: 25, “Address”: { “streetAddress”:”21 […]

tFilelist- Latest file from directory

tFileList use case example iterates on files or folders

tFileList retrieves a set of files or folders based on a filemask pattern and iterates on each unity. tFileList is the frequent use component which allows you to list down files, from provided directory. This post we will see different use case examples of tFileList. tFileList has following global variable. Global Variables List ((String)globalMap.get(“tFileList_1_CURRENT_FILE”)) this variable […]

Create File Name with Incremental Number Output

Create File with Incremental Number on each run of job

This post is based on  below comment from Mahesh who is facing problem, and wanted help from us. Here is the comment for reference.   Hi Umesh, the above post is very useful. Could you please help me out on this ? My requirement is :- The file which gets generated after running etl is “XYZ_20150603_1.csv” […]

Main, Reject, and Iterate connection sample job

How to Connect components with Triggers or Rows

Working on Talend there is always question about which connection (link between two component) should I use? In this post we are going to answer this question and also give more information about which connection will be executed first than other. If you are a beginner then this post is very use full to start with […]

Talend Date Routine-Function with examples- Part-2

  Last post we have cover following functions with sample example from Talend Date Routine. addDate(Date date, int nb, String dateType) addDate(String string, String pattern, int nb, String dateType) compareDate(Date date1, Date date2) compareDate(Date date1, Date date2, String pattern) getCurrentDate() getDate(String pattern) getFirstDayOfMonth(Date date) getLastDayOfMonth(Date date) getPartOfDate(String partName, Date date) getRandomDate(String minDate, String maxDate) isDate(String […]