How do i modify the output of my delimited file (csv) to be in a particular sequence.(i.e be in the format/sequence required by the third party system for upload). The output file is currently separated by ";" (semi colon). I want to include a static value(prefix) in all the rows and also do not want all of them to be separated by semi colon.
How do i go about this modification to generate my required output?
What you're describing isn't supported "out of the box" in Talend. You'll have to combine the data in the last column yourself. The best way to do that depends on what your incoming data looks like.
If the data is already together on one row, you'll want to combine the appropriate columns together, inserting your own delimiter (space) between the values.
If the individual values are on different rows, e.g.: User;Subject;Ferguson1 User;Subject;Mark1
...you can use an aggregate component with the List function to roll up the rows. The advanced settings tab of tAggregateRow lets you choose the delimiter for the List column.
Update after seeing your schema: Alter your tMap output schema to have only three columns. Make the third column's expression: row1.Firstname + " " + row1.Lastname
