Capture last years value

[ulysses_no]

Hi,

I have this table:

YEAR	WEEK	VALUE
2022	1	100
2022	2	101
2022	3	102
2022	4	103
2022	5	104
2021	1	105
2021	2	106
2021	3	107
2021	4	108
2021	5	109
2020	1	110
2020	2	111
2020	3	112
2020	4	113
2020	5	114
2019	1	115
2019	2	116
2019	3	117
2019	4	118
2019	5	119

I'm struggling with making a flow in Alteryx where I create a new column called "Last Year," and the logic should be that it should capture last year's value.

For example:

Last Year Value for the Year 2022, Week 1 --> should capture the Year 2021 Week 1 value.   Like this:

And it must be ISO safe (handle week 53 logic)

[atcodedog05 · Accepted solution]

Hi @ulysses_no 

Here is how you can do it.

Workflow:

Hope this helps : )

[RolandSchubert · Accepted solution]

Hi @ulysses_no ,

an approach could be a kind of " self-join":

Last Year is Year -1 - then join by  Year and week.

Let me know if it works for you.

Best,

Roland

[ulysses_no]

Thank you, guys! Both solutions worked like I wanted!  Thank you for your time and help!

[atcodedog05]

Happy to help : ) @ulysses_no 

Cheers and have a nice day!