Hi
All,
i have a file like this(data is like this)
a - -
- b -
- - c
and i want result is:
a b c
Thanks & Regards,
Madhava
solution
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 15
- Joined: Mon May 05, 2008 5:12 am
- Location: chennai
solution
Madhava
Re: solution
first try to replace your '-' with blank..........you will get column as
a
b
c
then using stage variable and hash file you will get the required format.
job design
seqfile--------->T1-------------->T2---------->HASHfile
in T1 do trim(ereplace(input.col1,"-",""))
in T2 do concat using stage variable.............use fixed value for key in hashfile like numeric value 1 or 2.........
a
b
c
then using stage variable and hash file you will get the required format.
job design
seqfile--------->T1-------------->T2---------->HASHfile
in T1 do trim(ereplace(input.col1,"-",""))
in T2 do concat using stage variable.............use fixed value for key in hashfile like numeric value 1 or 2.........
-
- Participant
- Posts: 15
- Joined: Mon May 05, 2008 5:12 am
- Location: chennai
getting solution
Hi
iwas getting answer,
seq.....> aggregator....... .>transfor........>seqfile
in Aggregator we r grouping max(col name) to all then we will get the required format
Regards,
Madhava.
iwas getting answer,
seq.....> aggregator....... .>transfor........>seqfile
in Aggregator we r grouping max(col name) to all then we will get the required format
Regards,
Madhava.
Madhava
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: