Multiplying multiple columns by fixed number

[Tomomichka]

How can I update the values in particular columns, with the values that are 100 times of the previous values? 

What I want to do is asshown in the picture. 

I do not want to create new columns, but rather want to replace the values with the ones 100 times of the previous values.

Thanks in advance.

[atcodedog05]

Hi @Tomomichka 

You can use Multi field formula tool to apply formula on multiple columns. Here is an example.

Here is an interactive lesson on it : https://community.alteryx.com/t5/Interactive-Lessons/Multi-Field-Formulas/ta-p/424422 

Hope this helps 🙂

[mceleavey · Accepted solution]

Hi @Tomomichka ,

this can be achieved by a simple multi-field formula:

Hope this helps.

M.

[Qiu]

@Tomomichka 

A combination of Cross Tab and Transpose should do it.

[Tomomichka]

Thank you so much! The link for the lesson was also very helpful.

[Tomomichka]

Thank you! I was new to Altreyx. Yeah, it turned out to be pretty simple. Thank you so much.

[Tomomichka]

Thank you! I should definitely look at those functions, which I have never used.