Blog

Load Data

21
Jun,2019

0

In this final section we look at the data load. Here we will use the same tUnpivot row component to transpose the actual row data into columns and assign the column values from the column_config file. In this we will…

Manage Order

21
Jun,2019

0

This section is direct extraction from Bekwam Blog Here we will assign the value of primary columns to a HashMap object called fieldname. Input file is the same input file from tFileList tJaveRow has the code to assign values. The…

Unpivot

21
Jun,2019

0

This section is where we need to transpose the row structure of the config file to columns so that we can use it as a lookup table later. We use tFile delimited with Column values ranging from Column0 to ColumnN with a…

Create Column Mapping

21
Jun,2019

0

In this section we will use the Limit property of tInputFileDelimited component and fetch only the column headers. then will load this into a file Set up of input file is as below. The key point to note here is…

Dynamic Schema in Talend Open Studio

20
Jun,2019

0

This week got a request from one of my client to process over 100 csv files into one master file with a unique schema using TOS. There were multiple challenges. The schema of each file were different. These files were…