I have two CSV files
1st file columns:
Serial NO,Error Message
2nd file columns:
Now we have to compare these two serial numbers if matches we have to append the error message from first file to second file for that particular serial Number.
This is the first CSV file
#20=123 In this 123 is my serial No.We have to extract 123 from the string
This is the second CSV file
Now if the Serial Numbers Matched then the Error message from First CSV should be copied to second CSV under a new column for that serial number.
Can anyone please help.
Last edited by mounica_ch (2016-07-01 11:59:14)
It sounds like your second file is you main flow and you first file (with error message) is a look-up, so you should be able to outer-join these using tMap.
You can then add the serial number from the main flow to the output, along with the error message from the lookup.
With your outer join, you can specify if you want to match all records, just the first, or just the last, depending on the uniqueness of your serial numbers.