Search found 2 matches

by Nniol
Wed Apr 26, 2017 6:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Add a single value into all rows of a job
Replies: 3
Views: 1508

Hi, but would lookup supply the same value to every row? Ok, it would, I would need to have some kind of key value in the input row say a constant "1", and then just insert this constant value in the output from the database read, giving me a row of 1, [input value]. I would then join on t...
by Nniol
Wed Apr 26, 2017 6:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Add a single value into all rows of a job
Replies: 3
Views: 1508

Add a single value into all rows of a job

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 val...