Multiplying multiple columns by fixed number

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.

Screenshot (38)_LI.jpg

Help

Accepted answers

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

Hope this helps.

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

Hope this helps 🙂

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

Hope this helps.

A combination of Cross Tab and Transpose should do it.

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

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