Cannot capture Transformation Processed Variable

More
7 years 11 months ago - 7 years 11 months ago #13885 by imchaz
I am using ETL Ver 5.8.3.5

In my screenshot dataflow.png
I am writing records to a good file and duplicate file
As you can see 136 records are being passed to the Good file and 3 files are being passed to a rejected file.
dataflow.png


In my screenshot DataFlow_ExecutionLog.PNG
It shows that it is executing properly.
DataFlow_ExecutionLog.PNG


In my screenshot PackageVariables.PNG, I can capture the <Transformation Rejected> variable as a 3, but the <Transformation Processed> is coming up 0.
I need to capture the count of the <Transformation Processed>
PackageVariables.PNG


My question is why the <Transformation Processed> is coming up 0 when it should be 136?
Attachments:
Last edit: 7 years 11 months ago by imchaz.

Please Log in or Create an account to join the conversation.

More
7 years 11 months ago #13886 by Peter.Jonson
<Transformation Processed> captures total number of records read by the reader.
For your case better option is to add Set Package Variable to the last transformer before writer and use it instead
Sequenence -> Set Package Variable

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
7 years 11 months ago #13887 by imchaz

Peter.Jonson wrote: <Transformation Processed> captures total number of records read by the reader.
For your case better option is to add Set Package Variable to the last transformer before writer and use it instead
Sequenence -> Set Package Variable

If I set the sequence and use the SET PACKAGE VARIABLE name to CountProcessedRecords

How do I call that variable from the PACKAGE area? In my SCRIPT Object how do I assign the variable properly so I can use as it flows to my SHOW MESSAGE object so I will know it counted properly?

Please Log in or Create an account to join the conversation.

More
7 years 11 months ago #13888 by Peter.Jonson
You just put variable name inside the text, and it will be replaced with actual value during execution.

Like here

www.etl-tools.com/wiki/aetle:packages:variables

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
7 years 11 months ago #13890 by imchaz

Peter.Jonson wrote: You just put variable name inside the text, and it will be replaced with actual value during execution.

Like here

www.etl-tools.com/wiki/aetle:packages:variables


Thank you for your reply but I am still not clear on it. Let me show you what I need to do to help explain it. According to you, I should set a SEQUENCE in my Transformation Editor prior going to the WRITER. Here is a pic of me doing so. I use the SET PACKAGE Variable called "CountProcessRecords"



Now when I execute the TRANSFORM Object in my PACKAGE as you can see I am executing the Transformation Object called "Validate WKS Duplicate Telemedicine". From within that object, it should use the PACKAGE Variable called "CountProcessRecords" and count how many records are being passed to the WRITER Object. Then I progresses to the SCRIPT Object called Pass Original Duplicate Telemedicine Records Variable". Here is where I need the help.
How do I retrieve the Variable "CountProcessRecords"? Then after I retreive it, I use the SHOW MESSAGE OBJECT to display the variable "CountProcessRecords"



Can you give me more concise instructions? I appreciate it.
Attachments:

Please Log in or Create an account to join the conversation.

More
7 years 11 months ago #13891 by Peter.Jonson
Type

Variable value is: CountProcessRecords

as message text and run the package
Than you will see what I mean

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.