Multiple Header's in Flat File

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ramesh9394
Participant
Posts: 14
Joined: Thu Jun 09, 2011 7:24 pm
Location: USA

Multiple Header's in Flat File

Post by ramesh9394 »

HI
i am getting a flat file with too many headers

ex

empno empname
1 krish
2 chris
empno empname
3 raghu
eampno empname
4 sri

like this
can any one please tell me how to remove those headers in Ds job
ram
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Re: Multiple Header's in Flat File

Post by qt_ky »

Parallel Job Developer's Guide wrote:When you are reading files, you can use a reject link as a destination for rows that do not match the expected column definitions.
Try going into the stage and changing the reject mode.
Choose a job you love, and you will never have to work a day in your life. - Confucius
pandeesh
Premium Member
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Post by pandeesh »

or, you can use filter option to remove those lines from the file:

Code: Select all

sed '/^Empno/d' 
something like this..
pandeeswaran
ramesh9394
Participant
Posts: 14
Joined: Thu Jun 09, 2011 7:24 pm
Location: USA

Post by ramesh9394 »

Thank's every one
my problem is resolved .now they are sending file with no header's
ram
Post Reply