12-04-2012 09:30 AM
I'm working in a User Written transformation in DI Studio. It has a DATA &_output step with the following statement: report_date = intnx('weekday', today(), -1);
The output work table has a column called report_date, which the value for the variable report_date appears in (as 03DEC2012).
If I want the User Written transformation to output TWO values to the report_date column, how do I do it? I basically need it to output both report_date = intnx('weekday', today(), -1); AND report_date_saturday = report_date +1; to the report_date work table column if run on a Monday (so that it outputs the date of Friday and Saturday).
If the job is run on 10DEC2012, the output work table should look like this:
Thanks for your time.
12-04-2012 03:01 PM
Whenever I try using the output statement, I get an error saying "ERROR 455-185: Data set was not specified on the DATA statement". The data step is data &_output;
Is it forbidden to use output inside an &_output data step, and if so, is there an alternative?
UPDATE: Nevermind, figured it out, thanks.
Need further help from the community? Please ask a new question.