hi,
I have 2 columns Date, Time and third column contains duration. i want to calculate the end date time based on these 3 columns. Can someone please throw some light to how to accomplish it efficiently as i ahve to process large amount of data. Also hows does PX internally manipulates the Datetime data.
p.s.
Is is possible to convert everything in Seconds and then adding the duration and convert it back to timestamp?
Thanks in advance.
End Date Calculation
Moderators: chulett, rschirm, roy
End Date Calculation
Regards,
Affan
"Questioning is Half Knowledge"
Affan
"Questioning is Half Knowledge"
If you concern is more into processing efficiency you may try using Modify stage instaed of transofmer stage.
You can find the simila funciton avialable there.
You can find the simila funciton avialable there.
Code: Select all
timestamp_from_seconds_since[timestamp](dfloat)
timestamp_from_date [time](date)
timestamp_from_time
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
But i have to transform the other columns as well i-e applying business rules to other columns, so is it a good idea to put the modify stage and then pass the data to transformaer for applying the business rules.
Also whats the best practice for the situation where mix of rules exist e.g. Data type Conversions, Date Claculations, Applying calculations.
Thanks in advance.
Also whats the best practice for the situation where mix of rules exist e.g. Data type Conversions, Date Claculations, Applying calculations.
Thanks in advance.
Regards,
Affan
"Questioning is Half Knowledge"
Affan
"Questioning is Half Knowledge"