We face a general problem in our Talend jobs, that is how to add new field in mid of the main flow. We will solve this problem by using SplitRow component.
In picture in FixedFlowInput we have a field named "first_name" with value "Brij" and we want to introduce one more field "last_name" in mid of our job flow.
We can use SplitRow component for the same. We generally think this component can only splits the row, but that is not correct we can add fields as well.
In SplitRow component we will add one more filed last_name and give it to any valuse (Sharma in this example).
In column mapping we need to re-assign the value for first_name by giving the code row1.first_name. We can give any expression in SplitRow component.
In picture in FixedFlowInput we have a field named "first_name" with value "Brij" and we want to introduce one more field "last_name" in mid of our job flow.
We can use SplitRow component for the same. We generally think this component can only splits the row, but that is not correct we can add fields as well.
In SplitRow component we will add one more filed last_name and give it to any valuse (Sharma in this example).
In column mapping we need to re-assign the value for first_name by giving the code row1.first_name. We can give any expression in SplitRow component.
No comments:
Post a Comment