topic Re: How to capture tParseRecordSet output to global variable in Talend Studio

How to capture tParseRecordSet output to global variable

Anonymous — Tue, 22 May 2018 06:09:24 GMT

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

Re: How to capture tParseRecordSet output to global variable

manodwhb — Tue, 22 May 2018 06:23:04 GMT

@amsrivastava,since you can use tSetGlobalVar.

check below link how to use tSetGlobalVar.

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

Re: How to capture tParseRecordSet output to global variable

Anonymous — Wed, 23 May 2018 11:09:21 GMT

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

Re: How to capture tParseRecordSet output to global variable

manodwhb — Wed, 23 May 2018 12:28:26 GMT

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

if yes use the tSetGlobalvarafter tLogrow using main.

Re: How to capture tParseRecordSet output to global variable

Anonymous — Wed, 23 May 2018 12:32:44 GMT

Hi @manodwhb

YES, i am getting the value..

Thanks

Amit

Re: How to capture tParseRecordSet output to global variable

manodwhb — Wed, 23 May 2018 12:34:10 GMT

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

Key give like Count and Value row2.Counts

Re: How to capture tParseRecordSet output to global variable

Anonymous — Wed, 23 May 2018 12:54:08 GMT

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

Re: How to capture tParseRecordSet output to global variable

manodwhb — Wed, 23 May 2018 12:56:25 GMT

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

Re: How to capture tParseRecordSet output to global variable

Anonymous — Wed, 23 May 2018 13:02:33 GMT

Hi @manodwhb,

I have used tJavaRow and got the global variable.

Thanks

Amit Srivastava

Re: How to capture tParseRecordSet output to global variable

Anonymous — Wed, 23 May 2018 13:03:16 GMT

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

Re: How to capture tParseRecordSet output to global variable

manodwhb — Wed, 23 May 2018 13:04:05 GMT

@amsrivastava,you were welcome.

Please accept the solution and provide Kudos also.

my mail id is manodwh.b@gmail.com.