Category: Data integration

How to create random test data in Talend

In some cases you are fortunate that decent test data is available, but unfortunately this is not always the case. Therefore I'm going to show you how you can easily create your own test data. This test data should be good enough for a development phase.

How to identify tMap errors in Talend

In this “how to” you will see a tMap functionality that makes it a lot easier to debug tMap errors, especially when you are using a lot of data, columns or converts. Before I knew about this functionality I used to spent a lot of time on solving nullpointer exeptions and all kind of convert errors.

How to built a JSON string with arrays in Talend

In this “how to” you are going to learn how to build a job that produces a JSON string that can be stored to disk or sent to a REST API, for example. I have used the tJSONDoc components from the Talend Exchange for this “how to” because Talend Open Studio doesn’t provide an easy component

How to split files depending on column values

This post describes an easy way to split files into separate files depending on the column values of your input input file. When you allways expect the same values u can use the tFilterrow compoment, but when the values are different each time it’s a lot easier to do it this way.

How to validate a csv header

This post describes an easy way to check if the column header of a .csv file matches the requirements. You can download the sample HowToCheckCsvHeader.csv and use it to build your own job.

How to enable tHashInput and tHashOutput

The tHash (tHashInput and tHashOutput) components are very usefull to use in your jobs. Talend does not automatically enable these components for use in jobs. To enable the tHashInput and tHashOutput components perform the following instructions: 1: On the main menu navigate to File –> Edit Project properties 2: Select Designer –> Palette Settings 3:
Assign a menu in the Left Menu options.
Assign a menu in the Right Menu options.