How to capture tParseRecordSet output to global variable

[Anonymous]

Hi,

I have used tParseRecordSet which capturing output of SP.

I want to capture Output of tParseRecordSet to Global Variable.

Please suggest how to do this activity.

Thanks

Amit Srivastava

[manodwhb]

@amsrivastava,since you can use tSetGlobalVar.

check below link how to use tSetGlobalVar.

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/xx0nz4uGJnqyc7dKOLN4Wg

[Anonymous]

HI @manodwhb,

My requirement is as below

Detail

1. Stored procedure returns Counts of table and same has been captured in tParseRecordSet (Column Counts)

Requirement

- to capture output (Counts) in Global Variable.

How to capture output of tParseRecordSet to GlobalVariable so that i will use the same further in ETL.

Please suggest!!

Thanks

Amit Srivastava 

[manodwhb]

@amsrivastava,could you able to get the count to tLogrow?

if yes use the tSetGlobalvarafter tLogrow using main.

[Anonymous]

Hi @manodwhb

YES, i am getting the value..

Thanks

Amit 

[manodwhb · Accepted solution]

@amsrivastava,then use tSetGlobalVar as shown below.this should work.

Key give like Count and Value row2.Counts

[Anonymous]

Hi @manodwhb,

I have done the following

Overall

tSetGlobalVar

tJava
Output

Still not getting value, getting Null

Please suggest where i have done wrong

Thanks

Amit Srivastava

[manodwhb]

@amsrivastava,use tMap/tJavaRow and get the global variable.

[Anonymous]

Hi @manodwhb,

I have used tJavaRow and got the global variable.

Thanks

Amit Srivastava

[Anonymous]

Hi @manodwhb,

That works!!! Thank you!!!

Can you please provide your personal Email Id so that we can issues on Talend.

Also, is there another way to capture Output of Stored Procedure in Global variable other than above.

Thanks

Amit Srivastava