Hi,
I need some advice on date function in parallel extender. I want to have data for only the current quater from dataset.
My job would be
Full_Data_dataset ---> transformer/Filter_thisQuaterData ----> ThisQuaterData
Please let me know what is the solution.
I can do it using server routine but then unable to call the server routine from the Parallel Job.
date function in parallel Job
Moderators: chulett, rschirm, roy
date function in parallel Job
----------------
Rgds,
Anupam
----------------
The future is not something we enter. The future is something we create.
Rgds,
Anupam
----------------
The future is not something we enter. The future is something we create.
anupam,
if performance is not an issue, you can always use a BASIC transform stage in a parallel job and enjoy all the benefits of the ICONV/OCONV functions for date conversions.
You can use the builtin date conversions in Px such as DateToString to perform your cast to the new data column. Another way would be to keep the datatype until you do your database write and use to_char() in the SQL.
if performance is not an issue, you can always use a BASIC transform stage in a parallel job and enjoy all the benefits of the ICONV/OCONV functions for date conversions.
You can use the builtin date conversions in Px such as DateToString to perform your cast to the new data column. Another way would be to keep the datatype until you do your database write and use to_char() in the SQL.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
MonthFromDate(<date in the full data set>) would give you month number and quarter can be derived based on the month number and you should have current quarter in a parameter. So current quarter can be filtered in the filter stage.
I have no idea whether this is better way of getting the quarter in PX.
HTWH.
Regards
Saravanan
I have no idea whether this is better way of getting the quarter in PX.
HTWH.
Regards
Saravanan
Hi,
The way to find out the 1st date of this quater is not a problem
Oconv(QUARTER.FIRST(Oconv(date(), "D4Y"):"Q":Oconv(date(), "DQ")) ,"D-YMD[4,2,2]")
But the problem now is when using this code in server job it is absolutly working fine. But when i use this piece of code in Parallel Jobs then i am getting null in this particular column as an output.
Any Suggestions...
The way to find out the 1st date of this quater is not a problem
Oconv(QUARTER.FIRST(Oconv(date(), "D4Y"):"Q":Oconv(date(), "DQ")) ,"D-YMD[4,2,2]")
But the problem now is when using this code in server job it is absolutly working fine. But when i use this piece of code in Parallel Jobs then i am getting null in this particular column as an output.
Any Suggestions...
----------------
Rgds,
Anupam
----------------
The future is not something we enter. The future is something we create.
Rgds,
Anupam
----------------
The future is not something we enter. The future is something we create.
anupam,
have you use a BASIC transformer stage and not a normal transformer stage in the Px job?
have you use a BASIC transformer stage and not a normal transformer stage in the Px job?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>