Need to direct the output to an excel template.
Posted: Thu Dec 06, 2007 8:51 pm
I have a datastage Job that gathers statistics from a number of tables and then outputs the result to an excel file.
Currently I am manually copying the results to a specific worksheet(WA2) in an excel file. Another worksheet(WA1) summarizes the results using excel's lookup function.
I am trying to see if I can avoid the part where I have to manually do a copy and paste. Is it possible that I output the results directly to a template ?
If so, please suggest a way to automate it
Thank You.
Currently I am manually copying the results to a specific worksheet(WA2) in an excel file. Another worksheet(WA1) summarizes the results using excel's lookup function.
I am trying to see if I can avoid the part where I have to manually do a copy and paste. Is it possible that I output the results directly to a template ?
If so, please suggest a way to automate it
Thank You.