DSXchange

You CAN omit fields as you read. Use the Drop on Input property in the extended column definition.

Well... that's a little misleading. They are still read, they're just not propagated downstream. Dropping them after input is not the same as not reading them at all, which is how I interpreted the OP's quest. Besides, you still have to fully specify them in the input data, something else the OP is trying to avoid.

Read all the columns from file and then map only the columns that you want in transformer stage.

you can use below unix command in sequential file stage

cut -d"," f1,f2 <filename>
where f1&f2 are filed names

Hi,

'cut' command is a useful awk command to do this selective stuff

regards
Sreeni