topic Re: Fill down columns from the first row data AND filter by date in Alteryx Designer Desktop Discussions

Fill down columns from the first row data AND filter by date

ericren — Thu, 08 Jun 2023 11:24:35 GMT

Hi Alteryx community,

See below.

For Current Date I want to fill down with the constant date 6/2/2023.

For Previous Date I want to fill down with the Current Date - 7 days.

Finally I want all rows with Action date between current date and previous date.

FrederikE — Thu, 08 Jun 2023 11:32:52 GMT

"Between" as a function is availible since 2023.1 - if you haven't got this you can use

[Action Date]> [Previous Date] AND [Action Date]<[Current Date]

Instead

ericren — Thu, 08 Jun 2023 11:40:02 GMT

No sure why, the current date and previous date columns are not filling in. Would I need to use a multi field formula?

FrederikE — Thu, 08 Jun 2023 11:52:08 GMT

Ah, you want to populate the first value downwards - Missunderstood you there. Multi-Row is the tool for this.

ericren — Thu, 08 Jun 2023 12:06:56 GMT

Yeah Im having issues with the rows filling, see below if we are getting the same result.

binu_acs — Thu, 08 Jun 2023 14:39:16 GMT

@ericren One way of doing this