This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I filter all "bad" data to the True-Anker of the Filter tool and all good data to the "F"-Anker. I missed the Unique Tool in my first description, but off course we don't want to multiply the data, therefore I use the Unique on 'codigo_ibge'.
The Join-Tool basically does a field swap without swapping the date. I than combine everything back together using the Union Tool and sort it.
Workflow attached. Let me know if this solved your problem.
2020-05-23-How to fill the lines of a table based on values of one column.yxmd