rado98 Contributor

Uploading the spreasheet using the workbench will allow you set the column type to text at source level.

Hi. It worked find thank you very much

The issue was resolved by reinstalling the workbench. Now I can export and import the same job as it should

There is probably a less convoluted way of doing it but thisis how I managed to getting it done: Create the following individual subtitutions and set them to STRING type: SUBSTITUTE(`Date`," 12:00:00 AM","" ) SUBSTITUTE(`Time`,"30/12/1899 ","") Put together the "extrated" Date and Times and set to DATETIME type…

Hi Thanks for the help, however the Workbench does not have STR_TO_DATE unfortunatelly. So I still need a way to do it in Workbench. On a side note" I had to modify the Beast Mode calcuation to get ti to work to: STR_TO_DATE(CONCAT(`DateColumn`, ' ', TIME(`TimeColumn`)), '%Y/%m/%d %H:%i') the TIME() funcion being the key…

I fixed the issue by doign the following: * Opened .xls file using Excel 2013. * Saved the file as a .xlsx (or .xlsm) file * Closed the file * Opened the .xlsx version of the file (I had to do this step for one sheet) * Saved the file as .xls At that point I was able to use the file with workbench with no issues. I did not…

A duplicate function would be ideal. I have probably 10 or so WB job that would benefit from a duplication function. I am setting up DataSets from Excel spreadsheets so I find myself changing to the same schema and transforms over and over again just because similar data is set up across different tabs. Although I have…