Round of alternate rows differently if headers keeps changing

[sanchit]

Hi everyone, can anyone help me in a logic to format rows rather than doing it by columns as columns names are dynamic and will keep changing , Anyway to format alternate rows no matter what is the column header

today they are home, office, tommrow it can be tables,chairs. So headers are not fixed, any way to do this??

Category	Home	Office
Sales	100.9	200.9
Ratio	0.00002	0.00004
Profit	200.9	300.9
Ratio	0.00005	0.00004

[binuacs]

@sanchit you can use the Transpose tool to make it dynamic or one more option is to use the Multi-Field Formula

[flying008]

Hi,@sanchit 

please see that.

[sanchit]

@flying008 and @binuacs  In both the cases everything is formatted to two decimals, Ratios needs to be 5 decimal places and Sales 1 decimal accurate

[flying008]

Hi,@sanchit 

I'm already edited my post, please see above gif, maybe you need change the Output Type to Double of Multi-Field Formula tool. 

[sanchit]

@flying008 can you share the packaged flow Please

[flying008 · Accepted solution]

@sanchit 

1- the input data:

Category	Home	Office
Sales	100.9	200.9
Ratio	0.00002	0.00004
Profit	200.9	300.9
Ratio	0.00005	0.00004
Sales	100.26	0.123456
Ratio	10.25679	0.123456

2- the Expression of Multi-Field Formula:

Switch([Category],[_CurrentField_],"Sales",Round([_CurrentField_], 0.1),"Ratio",Round([_CurrentField_], 0.00001))

3- You need Change Output Type to "Double" after select the option for all "numeric" Fields.

[binuacs]

@sanchit in that case you need to add a conditional check in the formula tool

[sanchit]

Thank you, this is a better solution rather than transposing the data twice and can be accomplished in just one step. 

Accepting this as the best solution

[sanchit]

Thank you for taking time and wokring on this, this is also a acceptable solution but I would personally prefer the other one as it uses less steps.