how to replace the value of a row

luo

Hi Guys,

I got a input like

xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx
xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx
Total		2	3	4	2	4	7	9
xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx
xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx
Total	2		8	3	1	3	2		6

And I want a output like 

xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx
xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx
Total		1	1	1	1	1	1	1
xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx
xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx	xxxx
Total	1		1	1	1	1	1		1

The only way I figured out is to write a formular for each column. Is there an easier way? because I may have dozens of column. Thank you. 

fmvizcaino

Hi @luo ,

You can use a replace function inside a multi-field formula tool to dynamically replace all columns at the same time.

Best,

Fernando Vizcaino

2020-05-26 how to replace the value of a row.yxmd