Forum Discussion
How can I do an incremental refresh with null dates??
I would like to know if it is possible to do an incremental refresh or just a "reload" (working with a smaller range of dates on the desktop) and that this column of dates contain null dates .
For example, I have a [Payment Date] column, and I need it to have blank values in it.
I've already tried and it didn't work:
Select *
from table
where [Payment date) between Range start and RangeEnd or [Payment date] is null.
But the null values have duplicated
Is there another way?
2 Replies
You need to remember that RangeStart and RangeEnd identify the boundaries of the dataset table partitions. That's one of the reasons while only one of the parameters can be inclusive - otherwise you risk duplicating data across adjacent partitions. Same with your null dates. Unless you substitute these with a fixed date you will have duplicate rows in your partitions. You really don't want that to happen.
Hi Paguiar ,
Unfortunately, the feature you want is currently not available. Maybe you can sumbit an idea for it: Ideas
Date column - The table must contain a date column of date/time or integer data type. The RangeStart and RangeEnd parameters (which must be date/time data type) filter table data based on the date column. For date columns of integer surrogate keys in the form of
yyyymmdd, you can create a function that converts the date/time value in the parameters to match the integer surrogate key of the data source table. To learn more, see Configure incremental refresh - Convert DateTime to integer.Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
