Need help with identifying bad data in the dataset

Data Set:

I have above data set and I want to identify companies with no changes in the values over the period i.e KBC and . So that I can remove them from my dataset. Basically, I'm running linear regression model and trying to predict future values based on variable. batch macro is throwing an error for companies where no changes are observed as variable changes. Error: "The field "Fit_Stats" is not contained in the record". Can someone help me how can I remove such companies from my dataset.

Topic of Interest

Accepted answers

alisonpitt

You could also do this by working out the value of the change of each row (if you needed that for some reason) with a multi-row formula tool. I'm attaching a couple ways you could do it.

nochanges.yxmd

All comments

alisonpitt

If you run this data set through a Summarize tool, you could get the min/max for each CompanyName, and then those with min = max would be your "no change" companies. Then join this back and take the left or right outputs to get a data set that excludes the "no change" companies.

alisonpitt

You could also do this by working out the value of the change of each row (if you needed that for some reason) with a multi-row formula tool. I'm attaching a couple ways you could do it.

nochanges.yxmd

mahendra0393

Thank you Alison, This is what I was looking for.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703