I tried couple of things in DM. Including converting starttime and Endtime to in seconds as source in numeric hours value but converting back to time and adding with date I am having datatype issues in calculation. Is there a way in DM I can acheive this?
Please Let me know if more details are required.
Thanks you.This message has been edited. Last edited by: Bical,
WebFOCUS 8 Windows, All Outputs
October 12, 2015, 06:18 PM
dhagen
A lot of this stuff can be done in the meta-data without transformations.
No transformations necessary here. The DATETIME column is an actual date-time stamp.
"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
October 12, 2015, 06:31 PM
Bical
Thanks I should have mentioned my source data is coming from SQL Server and Target is Greenplum. I am creating a dataflow to load the data. Is this still works
WebFOCUS 8 Windows, All Outputs
October 12, 2015, 06:59 PM
Dan Satchell
This example, using the CAR file, shows some of the functions that might help you.
This message has been edited. Last edited by: Dan Satchell,
WebFOCUS 7.7.05
October 12, 2015, 08:16 PM
Bical
Thanks, I will give it a try meanwhile In my current logic I am getting error. I would like to know what am I doing wrong here.
--- Error Message--- 0 ERROR AT OR NEAR LINE 81 IN PROCEDURE __WCFEX FOCEXEC * (FOC224) SYNTAX ERROR: ; (FOC009) INCOMPLETE REQUEST STATEMENT BYPASSING TO END OF COMMAND --------------------------
Logic in DataMigrator: In select columns I am inserting below columns
1)Arrival_date = DATE(T1.ACTIVITYDATE_D ) 2)Arrival_Time = CASE WHEN T1.STARTTIME_T IS NULL THEN TIME('00:00:00.00000') ELSE TIME((EDIT(T1.STARTTIME_T , '$$99:99:00.00000' ) ) ) END
Thank you Dan, I give it a try and It worked. I am still trying to figure out why my logic didn't worked I am guessing It's bcs the space between date and time but not sure
WebFOCUS 8 Windows, All Outputs
October 13, 2015, 01:40 PM
Dan Satchell
quote:
(FOC224) SYNTAX ERROR: ;
The error message seems to indicate that you have an extra semi-colon near line #81 in your code.