Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

filter by date without losing query folding

Hi all,    I am using the HANA connector in import-mode to import a table which has a date-column. I want to filter the query based on this date-column, however it's not formatted as dates. I could...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi Anonymous 

     

    Changing the data type of a column in Power Query Editor will break query folding, so please delete the "Changed type" step. Then you can try Anonymous 's suggestions. If your date column in the data source is in number data type, filtering will not break query folding. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous - the value "yyyymmdd" is a date format, so do you mean that the data type of the column is not Date type.

If you are lucky, the data type might by INTERGER, so you can simply try INT > 20211230 and INT < 20220928.

If the data type is Text, this might still work TEXT > "20211230" and TEXT < "20220928".   Otherwise you may want try adding a new column which converts to INT.  See if it is still folding.  Then try to filter the new column.

If is Date Type, you may need to consider using Native Query to force folding to SAP Hana.