Add Value from File
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 48
- Joined: Wed Jan 07, 2015 3:30 pm
Add Value from File
Looking for a way to add a column and populate the value of that column for every row. The value of that column for every row will be coming a csv file with a date in it.
Could you expand on the problem you are facing? Adding a column to a job and processing that extra column in a DataStage job is quite easy, so I'll assume that you have some other issue.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 48
- Joined: Wed Jan 07, 2015 3:30 pm
-
- Premium Member
- Posts: 48
- Joined: Wed Jan 07, 2015 3:30 pm
That would typically be handled via a Sequence job and there are a handful of current topics on that subject over in the General forum. This one as one example, there should be plenty more. Basically you need something to 'read' the file and then pass the result to the Job Parameter in the Job Activity stage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Is there only one record in the file? Then 'reading' it might be as simple as using an Execute Command stage to cat the file to standard out and then you would need to capture the $CommandOutput from the stage to send to the parameter, something the Sequence job would automate for you.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 36
- Joined: Thu Dec 03, 2009 9:11 pm
- Location: Malaysia
Not really sure why they felt the need to heavily redact the screenshot of the job but also didn't really see a need for it to answer the question. IMHO.
Guessing they have some sort of proprietary naming system and they're simply protecting their IP.
Guessing they have some sort of proprietary naming system and they're simply protecting their IP.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 48
- Joined: Wed Jan 07, 2015 3:30 pm