In Sequential file output

[venkates.dw]

I am having sequential file as source....

my input data is

deptno,dname,loc
10,aaa,hyd
20,bbb,ban
30,,che

in third row i am not having the dname information ...

but i want to replace empty dname with 'xxxx'...

i.e.,

o/p:

dno,dname,loc
10,aaa,hyd
20,bbb,ban
30,xxxx,che

give the process please......

[kamalshil]

read the sequential file as i/p and feild delimiter as comma
then pass the output to transformer stage
and try to following logic:

Code: Select all

isNull(columnname) then
"XXX"
else
columnname 

And now pass this transformer result to target it will help.

[kandyshandy]

Venkates, better read DS documentation to know the basics of DS functionality.

[ray.wurlod]

Kamashil's suggestion will only work if your Sequential File stage that reads the file converts missing values to null. This is, of course, the default setting. If, however, you represent null differently, then you need specifically to handle the missing value differently, perhaps with a test against the literal string "".

[SagarMelam]

Create a stage variable for dname column and write the derivation as If (dname=''then 'XXXX' else dname).This will work check it out