Target file layout - Dynamic change

[vij]

Hi all,

I am creating a job, in which i am using a sequential file as target file.

My requirement is that the structure of the file, i mean the no. of the columns columns should change dynamically, based on a single value from the input..

for eg., if this is the i/p :

100,A1,234567
120,B1,123456789,abcdefg

the corresponding o/p should be:

100,A1,234567
120,B1,123456789,abcdefg

based on the value of 2nd column the number of columns shuld vary and only one output file should be used...

any help is appreiated.

Thanks

[chulett]

You are going to have to manage this. Assemble the record in a single large field, delimeters and all - then write it out to a Sequential File stage with one Varchar field and the Quote Character set to '000'.

[vij]

is there any stage which drops / keeps columns based on a condition?

eg.,
column1 =1, drop input column ...
or isnull(i/p column), drop it

like this?

We can use the modify stage for keep/drop columns, but i want to know is that possible to do the same based on some condtion ...

[kumar_s]

Read the file and pass it as a parameter to the next job based on the condition. I havent tested if Modify accepts paramter.