solution

[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

[wfis]

Please use a more meaningful subject line for your queries.
Search the forum for 'Pivot'. There are many posts matching your requirement.

[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.........

[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.

[ray.wurlod]

Please mark thread as Resolved.

The present tense plural form of the verb "to be" is spelled "are", not "r".