Add Value from File

cyclogenisis · Post by **cyclogenisis** » Fri Dec 11, 2015 2:11 am

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.

ArndW · Post by **ArndW** » Fri Dec 11, 2015 7:08 am

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.

cyclogenisis · Post by **cyclogenisis** » Fri Dec 11, 2015 9:49 am

I have some data coming down the pipe like this:

Need to add another column in the next step to this data that is coming downstream and the value for this column will be the same for every row. It is a date found in a csv file.

chulett · Post by **chulett** » Fri Dec 11, 2015 11:00 am

Create a job parameter to hold it and populate it using the file, then add the column in a transformer and reference the job parameter as the derivation.

cyclogenisis · Post by **cyclogenisis** » Mon Dec 14, 2015 3:21 pm

Sorry, how would you actually save the value from the sequential file to the job parameter?

chulett · Post by **chulett** » Mon Dec 14, 2015 4:26 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.

chulett · Post by **chulett** » Mon Dec 14, 2015 6:00 pm

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.

naveenkumar.ssn · Post by **naveenkumar.ssn** » Tue Dec 15, 2015 3:51 am

Hi

Could not view your image.

Can you put down as the text if possible

Regards
Naveen

chulett · Post by **chulett** » Tue Dec 15, 2015 8:33 am

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.

cyclogenisis · Post by **cyclogenisis** » Thu Dec 17, 2015 4:15 pm

Thanks chullett. Actually some of my links have table naming convention in them so I thought it would be best to take those out.

.