FOR_EACH_CSVROW

FOR_EACH_CSVROW

This is an iterator activity. It will read each row in a CSV file and on each iteration output first 50 column values found in the row.  The processing logic nested beneath FOR_EACH_CSVROW activity is repeated for each row read.

This activity supports reading up to 999 rows and outputs the value for up to 50 columns.  It is not intended for routine processing of large volumes of data.  It can be useful however for transferring limited amounts of information between activities, transformation maps and the processing sequence variable pool.

This activity will read only CSV file format.

This activity will read only the first 999 rows of a CSV file and the remaining rows are ignored.

This activity will output up to 50 columns of a CSV file and the remaining columns are ignored.

INPUT Parameters:

CSVFILEPATH : Required

This parameter must contain the path of the file to be read.

This activity reads only CSV file format.

eg C:\order.csv

or /orders/order_jan.csv

SEPARATOR: Optional

If a non-comma separator is used, this value should contain the separator character. The separator should be 1 character in length and can consist of any character.

OUTPUT Parameters:

CSVCOLUMN1CSVCOLUMN2
…
CSVCOLUMN50

These output parameters will contain the value for the corresponding column for each CSV row read, up to the number of columns present in the data or a maximum of 50 columns.