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.
Category: Data integration
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.
I this “how to” i’m going to show you how easy it is to get the longitude and latitude from google maps for you address data. You can use this data for your PowerBi dashboards for example. Before you can start you need to install the tGoogleMapLookup component.
Do you want to add a rowNumber to your output then you really have to read this “how to” and learn how to do it! I needed it to add an order line number to my XML file.
A visitor of TalendHowTo asked me if there’s a way to split a file into seperate files based on a column value without using a subjob. My answer: offcourse there is!
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
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.
When you want to change the date pattern of your received string and you don’t want to use a date format as an output then use the statement of this “how to”.
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.
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: