Icon

Get every date between 2 limits without loop

Sample dataGet the lower dateNumber of DaysGenerate requirednumber of rowsGet sequence within groupThis will becomea "group" numbergenerate dateusing offsetSubtract 1 fromrank to useas an offsetfrom lower datetidy uprename toGenerated DateTable Creator Date&Time Shift Math Formula One Row to Many Rank Counter Generation Date&Time Shift Math Formula Column Filter Column Rename Sample dataGet the lower dateNumber of DaysGenerate requirednumber of rowsGet sequence within groupThis will becomea "group" numbergenerate dateusing offsetSubtract 1 fromrank to useas an offsetfrom lower datetidy uprename toGenerated DateTable Creator Date&Time Shift Math Formula One Row to Many Rank Counter Generation Date&Time Shift Math Formula Column Filter Column Rename

Nodes

Extensions

Links