I need your help to solve a technical problem in ADF Dataflow.
data
my_dataflow
I need to merge rows where the dates cross or touch each other. The problem is that I can't manipulate a variable to increment in dataflow to get the following result (in yellow).
This result would allow me to group the rows together.
I don't know how implement it into dataflow
The logic will be :
CASE(nrow == 1, my_variable = 1,
endDate > startDate-1 || endDate == startDate-1,my_variable,
my_variable + 1
)
Do you have a solution to work around this problem?