DSXchange

I have a requirement to create a pipe delimited sequential file out of a table extract. I have a table with 150 columns and I'm using column export stage to cretae the file. In this process, I have to go look the order of columns and select from the properties , manually add each column in the same order as in the table.
Its really difficult to select each column manually. Also, there are instances where we are missing one column and the whole order changfes in the ouput file.
Is there any way to avoid this effort and have the column export be done in a simple way ensuring the sequence of columns selected in export is same as the source?

Please help

dsnk wrote:Its really difficult to select each column manually.

No it's not. Be vigilant.

<Apostrophe Man>
It's "it's" when it's "it is", and it's "its" any other time.
</Apostrophe Man>

Another option is to use a schema-file containing the columns in the correct order.