Vector

[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

[ray.wurlod]

You probably need a Split Vector stage. Check out the stages in the Restructure folder.

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

[ray.wurlod]

Vectors are not the same as subrecords. To decompose a subrecord you need to use either Split Subrecord or Promote Subrecord stage.

[murari83]

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.

[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

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.