Query on updating table in Alteryx

[kafka_u21]

Hi,

I am stuck in a situation to solve this in Alteryx.

Basically the below is my current table

ID	Value	Date	Flag
1	0	Sep 25 2023	Y
2	10	Sep 26 2023	Y
3	0	Sep 18 2023	Y
4	20	Sep 19 2023	Y
5	0	Sep 11 2023	Y
6	30	Sep 12 2023	Y

Basically you can see all the value for Monday's are 0. i need to take the next day's value for all the dates when previous date is 0 & populate into a table as below with flag as N for the monday's record

ID	Value	Date	Flag
1	0	Sep 25 2023	N
1	10	Sep 25 2023	Y
2	10	Sep 26 2023	Y
3	0	Sep 18 2023	N
3	20	Sep 18 2023	Y
4	20	Sep 19 2023	Y
5	0	Sep 11 2023	N
5	30	Sep 11 2023	Y
6	30	Sep 12 2023	Y

[Yoshiro_Fujimori]

Hi @kafka_u21 ,

For simplicity, I assumed the Monday data always has Tuesday data right below.

I hope it helps.

Workflow

[sparksun]

Here is my solution：

[flying008]

Hi, @kafka_u21 

FYI.

Input
ID	Value	Date	Flag
1	0	Sep 25 2023	Y
2	10	Sep 26 2023	Y
3	0	Sep 18 2023	Y
4	20	Sep 19 2023	Y
5	0	Sep 11 2023	Y
6	30	Sep 12 2023	Y
Output
ID	Value	Date	Flag
1	0	Sep 25 2023	N
1	10	Sep 25 2023	Y
2	10	Sep 26 2023	Y
3	0	Sep 18 2023	N
3	20	Sep 18 2023	Y
4	20	Sep 19 2023	Y
5	0	Sep 11 2023	N
5	30	Sep 11 2023	Y
6	30	Sep 12 2023	Y

[kafka_u21]

All the 3 solutions worked out. Thanks so much.