Start Free Trial

Alteryx Designer Desktop Discussions

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

Extract only year

sanastasova
7 - Meteor

Hi, 

 

I am very new to Alteryx. I have a certain dataset ( column A) that contains products with different year. I want to create a new column that contains only the year of the product ( like column B - blue) . 

 

sanastasova_0-1643809904896.png

 

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @sanastasova 

 

Please provide this data in excel to work with.

 

Happy to help : )

atcodedog05
22 - Nova
22 - Nova

Hi @sanastasova 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1643810461123.png

 

Hope this helps : )

 

sanastasova
7 - Meteor

Thanks it worked :).

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @sanastasova 

Cheers and have a nice day!

Labels
Top Solution Authors