Applying formulas dynamically

Hi Folks,

I have a data set

I have added 3 new columns used a formula tool with the below formulas in it

But if any one of the column is removed from the Data set, the formula tool should not use the formula related to that column.

For Eg - If column "Item No C" is removed from data set then the formula tool should drop the third formula which uses column "Item No C" otherwise it will throw an error. It should be done dynamically.

Thanking you in advance.

Mustafa

Test.yxmd

Datasets

Accepted answers

echuong1

A more dynamic method of achieving this is with a multi-field formula. Essentially, this will allow you to deploy a formula to multiple columns at once - simply check off the fields that the formula should be applied to at the top. There is an unknown fields as well, so you can account for any new fields that show up later on. If a field is removed from the dataset, it will just ignore it, similar to a Select.

Test.yxmd

All comments

AngelosPachis

Hi @MKanchwa ,

What you can do to make this dynamic is to first transpose your columns to rows. Then that error won't appear if one of the columns is not present

Hope that helps, let me know if that worked for you.

Regards,

Angelos

example.yxmd

echuong1

Test.yxmd

AngelosPachis

@echuong1 your way is much simpler I think.

The only drawback that I can think is that if a column is not present, then the multi-field formula tool will throw a warning to you which might be disturbing if you are working with a big dataset.

On the other hand, this might also be a plus because the tool gives you a heads up. Really cool and it didn't cross my mind.

EDIT : the warning was not a cause of the multi-field formula. Advice of the day is to read the whole warning sentence

Thanks

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703