Skip to content

dsietz/talend-tcsvstring

Repository files navigation

License

tCSVString

  • Version 1.0

Converts all the rows and their columns to a single csv formated string. The csv string is not in the output row. Use the component property CSV_TEXT to retrieve the value.


Overiew of job flow

Alt text

Retrieving the CSV string

  1. Provide rows of data with columns as part of the flow (e.g.: database query) +NOTE: The tCSVString component will pass through the rows of data so you can insert it in the middle of your flow.
  2. Retrieve the CSV string after the flow has compelted by calling tCSVString component's CSV_TEXT property.

Alt text

Save the CSV string as a *.csv file

  1. Pass the csv string to a tFileOutputRaw component

Alt text

CSV file content

Alt text