Configure incremental refresh - Calculated Field

Question & Answer
, ,
1

Hello,

I have a date column on my dataset but it is with integer type, I want to use this column to triggers the incremental refresh. So I created a calculated field to transform this columns to date field, I made this because when I configure the schedule for incremental refresh the date columns appears.
But once I configurated the new column that column don’t appears as an option in the configure incremental refresh.
Any ideia if its possible to use a calculated field as an trigger for the incremental refresh?
The transformation was made like this:
parseDate(concat(substring(toString(data), 7, 2),‘/’,substring(toString(data), 5, 2),‘/’,substring(toString(data), 1, 4)),‘dd/MM/yyyy’)

the integer was like this: yyyyMMdd

Thanks,
Cinthya Oestreich

2

I don’t believe this is possible. Why can’t you make a field like this in SQL?

3

Hi @Cintha.Oestreich

We have not heard back from you regarding your question. We would still like to help. If we do not hear back in the next 3 days, we will archive the question.

4

Hi @Cintha.Oestreich, Since we have not received a response from you on this question, we are going to archive the question. If you still need this question answered, please create a new question topic