Four Stars

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.

Can anyone please help.
Thanks
2 REPLIES
Five Stars

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.
Four Stars

Re: Appending a column to a single row in an existing CSV

But my lookUp file is as follows

the right side value of #20 is my serial No which needs to be compared with the serial No in the second file.