i have 3 records,in that i want to delete first record

pavankatra · Post by **pavankatra** » Wed Apr 06, 2011 4:25 am

Hi ,
I want to delete the first record from below example

eno,ename,sal
100,abc,16678
100,xyz,77878
100,rts,6464884

from above list i want to populate last two rows to target.

can anyone help me on this

thanks inadvance

GJ_Stage · Post by **GJ_Stage** » Wed Apr 06, 2011 4:34 am

Hi , Is the values are from DS or Table ?

GJ_Stage · Post by **GJ_Stage** » Wed Apr 06, 2011 4:35 am

If it is in ds then put filter condition or if it is table use where condtion other than this record.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 06, 2011 4:37 am

Use a constraint expression in a Transformer stage or a Filter stage that does not pass ename='abc'