Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

last 10 year calculations based on

adarsh2608
8 - Asteroid

Hello All,

 

 excel , in each row in column i have value range from 0 to 9. which altreyx should identify 0 as 2020 , 1 s 2021 , 2 as 2022 ,3 as 2013 , 4 as 2014 , 5 as 2015, 6 as 2016 ,7 as 2017 , 8 as 2018 and 9 as 2019 (2013 to 2022) as this will consider last 10 years( dynamic and the  next year it will 2014 to 2023).

So can any one able to help to build condition ( this dynamic as  every year last 10 change from existing year)

9 REPLIES 9
TheOC
15 - Aurora
15 - Aurora

hey @adarsh2608 

Can you please provide us with a sample input (and output) of what you are trying to achieve?

Thanks,
TheOC


Bulien
Kamran1991
11 - Bolide

It can be possible through  'Multi-row formula'. Enter 10 in 'Num Rows' and take  value from 'Row-10' in current row.

 

If you can provide the sample input and expected output, it will be easy to answer you query in a better way.

 

Thanks,

Kamran

adarsh2608
8 - Asteroid

Hello All,

 

I have attached a sample excel , here the date calculation is dynamic based on current year to calculate to last 10 years(i.e 2022 -2013)  as next year it calculate based on that year to last 10 year i.e (2023-2014) and value shown in the excel are in not in order it is placed as random 

ArtApa
Alteryx
Alteryx

Hi @adarsh2608 - From what you wrote above, you simply need the last digit. Here is how you can achieve it:

 

ArtApa_0-1649570094847.png

 

adarsh2608
8 - Asteroid

Hello ,

 

Thank you for replying , But the value is only date I  get from excel to which i need to figure out the year .  since year should be dynamic as the year changes next year 

Akash__on
8 - Asteroid

share the sample data... and desired output 

adarsh2608
8 - Asteroid

Hello Akash

 

I have attached sample excel which i have created , here i will receive 'values' from input data and from the values i need to identify the year . this is calculated based last 10 years ( 2022-2013) which is dynamic . this will change in next year (2023-2014)

as i have mentioned in the main question it should identify 0 as 2020 , 2 as 2022  and 3 as 2013 etc

OllieClarke
15 - Aurora
15 - Aurora

Hi @adarsh2608 

I think I've understood you, you get the value column and you want to work out the year from it. So 2 would be 2022, but 3 would be 2013 (as it's not yet 2023).

 

If so, this workflow/formula tool should get you where you need to be :)

OllieClarke_0-1649695110533.png

 

 

Hope that helps,

 

Ollie

adarsh2608
8 - Asteroid

Thank you @OllieClarke

Labels