Add a single value into all rows of a job
Posted: Wed Apr 26, 2017 6:27 am
Hi,
I have a key value which I am loading in from a database (not a problem), there is just one value in one row here.
I now have an input set of data (currently in XML) which I am parsing into a column structure using Hierarchical Stage. This also works fine.
What I want to do is add the single value I load from the database into each row generated by the hierarchical stage. I can do this in the hierarchical stage, before or afterwards.
The final output will be input into a database table.
So how do I add this single value into every row which is input as XML?
Many thanks
Nniol
I have a key value which I am loading in from a database (not a problem), there is just one value in one row here.
I now have an input set of data (currently in XML) which I am parsing into a column structure using Hierarchical Stage. This also works fine.
What I want to do is add the single value I load from the database into each row generated by the hierarchical stage. I can do this in the hierarchical stage, before or afterwards.
The final output will be input into a database table.
So how do I add this single value into every row which is input as XML?
Many thanks
Nniol