Page 1 of 1
Vector
Posted: Fri Mar 19, 2010 6:42 am
by murari83
Hi
How to convert vector date to normal data.
eg:[1 2] Vector data
I nedd to convert to normatal data like 1 2
Posted: Fri Mar 19, 2010 3:03 pm
by ray.wurlod
You probably need a Split Vector stage. Check out the stages in the Restructure folder.
Posted: Sat Mar 20, 2010 12:02 am
by Gokul
We tried using the split vector. But its give compiatio error saying that the stage we cannot convert variable vector to fixed vector.
The orignal vecto was created by using make_subrecord stage.
Posted: Sat Mar 20, 2010 1:23 am
by ray.wurlod
Vectors are not the same as subrecords. To decompose a subrecord you need to use either Split Subrecord or Promote Subrecord stage.
Posted: Fri Mar 26, 2010 1:43 am
by murari83
ray.wurlod wrote:You probably need a Split Vector stage. Check out the stages in the Restructure folder. ...
Hi Ray,
please verify the below information
Input
------
Accno name sum
10 a 1
10 a 2
20 b 3
20 b 4
Job design
-----------
Dataset --------------->Combine_records (stage)--------->dataset
key:accno
Subrecordoutout colum:Final
we getting this out put
final accno
----- -------
[(a 1) (a 2)] 10
[(b 3) (b 4) 20
after in out put i am using this stage
Dataset--------------------> split_subrecord------------>dataset
subrecod colum: final
out put
--------
sum accno
----- ---------
[1 2] 10
[3 4] 20
I am receiving the above out as fixed vector
I required for the normal format like
1 2 10
3 4 20
Cany you please give your suggesitions.
Posted: Fri Mar 26, 2010 2:15 am
by G.K.K
Hi murali,
when i tried the first job that you gave in job design, it i sthrowing the below warning:
Input dataset does not have field: "accno"
Thanks
G.k.K
murari83 wrote:ray.wurlod wrote:You probably need a Split Vector stage. Check out the stages in the Restructure folder. ...
Hi Ray,
please verify the below information
Input
------
Accno name sum
10 a 1
10 a 2
20 b 3
20 b 4
Job design
-----------
Dataset --------------->Combine_records (stage)--------->dataset
key:accno
Subrecordoutout colum:Final
we getting this out put
final accno
----- -------
[(a 1) (a 2)] 10
[(b 3) (b 4) 20
after in out put i am using this stage
Dataset--------------------> split_subrecord------------>dataset
subrecod colum: final
out put
--------
sum accno
----- ---------
[1 2] 10
[3 4] 20
I am receiving the above out as fixed vector
I required for the normal format like
1 2 10
3 4 20
Cany you please give your suggesitions.