Round of alternate rows differently if headers keeps changing

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

Macros

Transformation

Dynamic Processing

Behavior Analysis

Accepted answers

flying008

@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.

All comments

binu_acs

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

Round_26_04.yxmd

flying008

Hi,@sanchit

please see that.

录制_2022_04_26_15_05_45_194.gif

sanchit

@flying008 and @binu_acs 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

@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.

binu_acs

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

Round_26_04.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703