No output from job using vectors

[jyothisdasms]

Hi,
i am trying to make a subrecord by combining two vectors.I am using a subrecord stage for that.

My Input fields are

Columnname1 columnname2 Key
[17095 130000 25] [Ajai Bhupi PM] 1
[17878 145000 30] [Das DAS RM] 2
Output fields are

Key Parent

But i am not getting any values in the output field Parent

the output is like

"Peek_15,0: Key:1 Parent:[0:() 1:() 2:()]
Peek_15,0: Key:2 Parent:[0:() 1:() 2:()]
"

Please help me to slve this issue.

Thanks

[ray.wurlod]

Show us what "combine" actually means. Also, since there's no such thing as a "subrecord stage", please confirm the actual stage type that you're using.

[jyothisdasms]

Hi,

I need to combine the two vector fields and the desired output is

Code: Select all

Parent                               Key

[17095 130000 25 Ajai Bhupi PM]      1
[17878 145000 30 Das DAS RM]         2

I am using Make Subrecord stage for this.

Inside the stage using the options
Vector Column for Subrecord-Columnname1
Vector column for Subrecord -Columnname2

Subrecord Output Column-Parent

Thanks