Six Stars

How to capture tParseRecordSet output to global variable

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

1 ACCEPTED SOLUTION

Accepted Solutions
Twelve Stars

Re: How to capture tParseRecordSet output to global variable

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

 

Key give like Count and Value row2.Counts

Untitled.png

 

Manohar B
10 REPLIES
Twelve Stars

Re: How to capture tParseRecordSet output to global variable

@amsrivastava,since you can use tSetGlobalVar.

 

check below link how to use tSetGlobalVar.

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

Manohar B
Six Stars

Re: How to capture tParseRecordSet output to global variable

HI @manodwhb,

My requirement is as below

 

1.JPGDetail

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

2.JPG

 

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 

Twelve Stars

Re: How to capture tParseRecordSet output to global variable

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

if yes use the tSetGlobalvarafter tLogrow using main.

Untitled.png

Manohar B
Six Stars

Re: How to capture tParseRecordSet output to global variable

Hi @manodwhb

YES, i am getting the value..
4.JPG

Thanks

Amit 

Twelve Stars

Re: How to capture tParseRecordSet output to global variable

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

 

Key give like Count and Value row2.Counts

Untitled.png

 

Manohar B
Six Stars

Re: How to capture tParseRecordSet output to global variable

Hi @manodwhb,

I have done the following

 

Overall

5.JPGtSetGlobalVar

6.JPG

tJava
7.JPGOutput

8.JPG

Still not getting value, getting Null

Please suggest where i have done wrong

 

Thanks

Amit Srivastava

 

Tags (1)
Twelve Stars

Re: How to capture tParseRecordSet output to global variable

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

Untitled.pngUntitled.png

Manohar B
Six Stars

Re: How to capture tParseRecordSet output to global variable

Hi @manodwhb,

 

I have used tJavaRow and got the global variable.

 

Thanks

Amit Srivastava

Six Stars

Re: How to capture tParseRecordSet output to global variable

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

Tags (1)
Twelve Stars

Re: How to capture tParseRecordSet output to global variable

@amsrivastava,you were welcome.

Please accept the solution and provide Kudos also.

 

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

 

Manohar B