Hi
How to convert vector date to normal data.
eg:[1 2] Vector data
I nedd to convert to normatal data like 1 2
Vector
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Ray,ray.wurlod wrote:You probably need a Split Vector stage. Check out the stages in the Restructure folder. ...
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.
m.ramakrishna
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
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:Hi Ray,ray.wurlod wrote:You probably need a Split Vector stage. Check out the stages in the Restructure folder. ...
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.