Automating Replacing Column/Row Values With Existing Data, Rule Engine?

My question is: instead of stringing 25 Rule Engine adjustments (one for each missing data column), is there a way to better automate replacing the missing data?

I have a series of 74 categories of data using short-term data (3 year range) and separately long-term data (10 year range), so I can perform percentage change and rate of change analyses between the ST and LT data (easy, math formula).

However, 2 of the 74 categories do not have long-term data; they’ve only existed long enough to populate short-term data.

Therefore, I get missing (“?”) data in a series of 25 or so columns where the long-term data does not exist. Using the Missing Value node I replaced the missing data with a number I don’t expect to ever populate (25,000,009).

I can now switch the dummy data with the actual short-term data so my percentage change and rate of change calculations show no change instead of blowing up due to missing data or a zero.

My question is: instead of stringing 25 Rule Engine adjustments (one for each missing data column), is there a way to better automate replacing the missing data?

Thanks for your help slight_smile: