I need one help to build below logic, we can use tMap or tJava.
My input and output is text file.
I want to populate Missing data using same value as first available value as per below screenshot.
above lookup can be used if required
Also Flag = "Y" can be used (denoted manually updated)
Solved! Go to Solution.
I am little late to the party as @shong has already provided a solution. Anyways here goes mine -
Job Layout -
So, basically using tSortRow and tFilterRow tried to find and filter out the non-empty records from the file and as a result tHashOutput would hold the distinct non null values from the input file.
On second step, read the file again and use tMap to join the original file content with the tHashOutput content to get the required output.
tMap configuration -