Page 1 of 1
solution
Posted: Wed May 21, 2008 5:33 am
by madhava1238
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
Posted: Wed May 21, 2008 5:58 am
by wfis
Please use a more meaningful subject line for your queries.
Search the forum for 'Pivot'. There are many posts matching your requirement.
Re: solution
Posted: Wed May 21, 2008 6:13 am
by sachin1
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.........
getting solution
Posted: Wed May 21, 2008 6:21 am
by madhava1238
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.
Posted: Wed May 21, 2008 3:21 pm
by ray.wurlod
Please mark thread as Resolved.
The present tense plural form of the verb "to be" is spelled "are", not "r".