I need to import an excel sheet data into a table. See the attached files.
Let me take the first 2 rows in Excel sheet as example. I have two places need help.
1. Imported dest table requestid field should be REQ120810-092 (format: REQYYMMDD-Log#, YYMMDD is the Date field in excel row.)
2. Split period & time columns in sheet and import in dest table as starttime & endtime fields with the format.
How can I achieve the above two tiems? Thanks.