Skip to Content
0
Jun 09, 2020 at 07:41 PM

Set a variable in a transform and access it in a transforms later within the same data flow

72 Views

Hi Experts,

Is there a way we can set the value of variable at run time in one transform and access that variable in some other transforms later in the same data flow?

We can set variables in pre/post loads but this does not allow us to set the variable values from within a transform.

For example say I want to set the total record count n in a transform A and then access that count to calculate the batch number in a query transform C after an XML Batch transform B in between. (In this example I am assuming we know the batch size x to calculate the batch count using n / x in Transform C)

Regards,

Sid