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
Target file layout - Dynamic change
Moderators: chulett, rschirm, roy
srop /keep columns conditionally
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 ...
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 ...