- Posts: 204
- Thank you received: 1
Cannot capture Transformation Processed Variable
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?
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
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.
If I set the sequence and use the SET PACKAGE VARIABLE name to CountProcessedRecordsPeter.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
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.
- Peter.Jonson
-
- Offline
- Platinum Member
-
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.
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.
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
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.