Concatenating Two Fields Using Pentaho Data Integration
In formal language theory and computer programming, string concatenation is the operation of joining character strings end-to-end. For example, the concatenation of “foot” and “ball” is “football”.
In programming, string concatenation generally occurs at run time, as string values are not in general known until run time. However, in the case of string literals, the values are known at compile time, and thus string concatenation can be done at compile time.
In this blog we will focus on how we can concatenate two fields using Pentaho’s drag and drop interface.
Initially we imported a sample CSV file and our objective is to concatenate columns product and values into a single column.
2. Now we dragged and dropped a concate fields step onto the canvas where we defined our target field name along with our input fields which make up the output field as one single concatenated field.
Finally we pushed the data onto a dummy step the screenshot for which is given below.Here we can see both the product and value columns are concatenated and made as a single “output” column.