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.
Note: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.