tr_ write_text creates a survey This trasformation shows how to generate a file. Normal 0 / ID_BATCH Y ID_BATCH CHANNEL_ID N CHANNEL_ID TRANSNAME Y TRANSNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED N LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD N LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER CLIENT N CLIENT ID_BATCH Y ID_BATCH SEQ_NR Y SEQ_NR LOGDATE Y LOGDATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS INPUT_BUFFER_ROWS Y INPUT_BUFFER_ROWS OUTPUT_BUFFER_ROWS Y OUTPUT_BUFFER_ROWS ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS LOG_FIELD N LOG_FIELD ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE METRICS_DATE Y METRICS_DATE METRICS_CODE Y METRICS_CODE METRICS_DESCRIPTION Y METRICS_DESCRIPTION METRICS_SUBJECT Y METRICS_SUBJECT METRICS_TYPE Y METRICS_TYPE METRICS_VALUE Y METRICS_VALUE 0.0 0.0 10000 50 50 N Y 50000 Y N 1000 2010/10/03 15:22:48.796 admin 2017/04/13 19:37:43.438 H4sIAAAAAAAAAAMAAAAAAAAAAAA= N Lab 2: Write Text File Output 112 32 211 30 Segoe UI 11 Y N 0 0 0 255 255 255 255 255 255 Y This guided demonstration illustrates how to write a file. The first part of the transformation, defines the 'head': Customer name: ------------------------------------ Please answer the questions below: Which is then apended to the 'body', which adds the questions.. 1. How many employees currently in your organisation? 2. Which ETL tool do you currently use? 3. What would you do if you had a magic wand? 112 80 567 361 Calibri Light 11 N N 0 0 0 255 255 255 255 255 255 Y survey questions question seq Y question seq select questions Y select questions Append body Y Append body TFO - survey Y name text +name Y text +name Append streams Y instructions Append streams Y Append streams Append body Y Append body Append Y 1 none Append streams select questions

672 432 Y Append streams Append Y 1 none text +name instructions

672 304 Y TFO - survey TextFileOutput Y 1 none ; " N Y

N

DOS None N Y ${Internal.Entry.Current.Directory}/survey N Y txt N N N N N N N N N 0 text String none -1 -1

816 432 Y instructions DataGrid Y 1 none text String -1 -1 N ---------------------------------------------------- Please answer the questions below:

512 304 Y name SystemInfo Y 1 none text command line argument 1

512 176 Y question seq Janino Y 1 none text question_num+". " + text String -1 -1 text

384 432 Y select questions SelectValues Y 1 none N question_num

512 432 Y survey questions TextFileInput Y 1 none N N " N

N

1 1 N 1 N 80 0 Y N Y N question_num mixed Characters Y ${Internal.Entry.Current.Directory}/questions.txt N N CSV None text String £ . , - -1 42 -1 none N 0 N N N warning error line Y en_US

256 432 Y text +name Janino Y 1 none text "Customer name: " + text String -1 -1 text

672 176 Y N