Forum Discussion

Eric's avatar
Eric
Advocate I
6 years ago
Solved

Convert YYYYMMDD String to DateTime w/o breaking query folding

The date field in my source file is stored as a string in YYYYMMDD format.  I need to convert it to a DateTime field in order to do incremental refresh and I need to do that without breaking query fo...
Need Help
  • Eric's avatar
    Eric
    6 years ago

    Thank you for the reply.  Yes, I have already tried the Table.TransformColumnTypes approach along with Table.AddColumn.  Both break query folding because I'm changing a text field to a date field.  Right now, I've switched back to odbc.query and I am pushing as much into the SELECT query as possible to leverage the service on the initial step.  It's not query folding but it may well improve performance, we'll see.

pade's avatar
pade
Advocate III
6 years ago

This is marked as solved without having a solution. I switch it back to new and hope for an answer.

 

Please make sure that the question is to be able to change existing or create a new column with a datetime format from an integer (or string) type column with dates in the format of YYYYMMDD, this while retaining the query folding towards the data source