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). [1] [2] [5] 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. [8] [7] 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:

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

mlauber71 August 29, 2024, 1:56pm 4

@creedssmith maybe you could use a loop. You have a list which two pairs of columns would be needed to fill the not existing one. Then in the loop you rename both to a standard value (_x_source, _y_target), then do the rule with the standard names, rename them back and collect the results.

3 Likes