Alteryx Formula tool

hello guys so i have to use the formula tool in order to create a new column that shows me the year of the manufacturing for the cars. The tasks sounds like " Create a new column “manufacturingYear” that shows the year for the products included in
productlines containing the word ‘Cars’. (Hint: look at the beginning of each product name for
the year). What would be the best formula to use/ best approach?

Thank you

Tips and Tricks

Accepted answers

@Claudiu159 One way of doing this

Find in attachement the way of doing this.

Please do not hesitate to accept this answer as solution if it helped.

Manufactury year.yxmd

All comments

@Claudiu159 You can use the Regex_Replace() formula to achieve your result. Can you provide a sample input file and expected output result?

I don' know if I understand well but If word "Cars" is always at the beginning of each line, you can use the Trim function to remove it.

Trim([Field],"Cars") should remove "Cars" as prefix or suffix.

If it's not clear, can you send us an input and the desired output?

I need to make a new column with manufacturingYear only for the ones containing the word Cars

Desired output is to have a new column called manufacturingYear only for the ones that include Cars in their name

@Claudiu159 One way of doing this

Thank you guys!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703