Appending a column to a single row in an existing CSV
Hi all I have two CSV files 1st file columns: Serial NO,Error Message 2nd file columns: Serial No 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.
Re: Appending a column to a single row in an existing CSV
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.