Using the Reformat Tool
Posted: September 15th, 2016, 5:11 am
Greetings
I created a rooster using a the first ten or so variables and then chucked away the rest meaning I took a rooster dictionary, truncated what I did not want, then edited my rooster from there. I further more re-used the same data sets as I needed the static data for household members.
The challenge is that on some slots where there is supposed to be blanks as nothing would have been entered, I get "dirty data" entered. This is causing quite a huge challenge when I export. How best can I use the Reformat Tool or any other for that matter to clean/ rid of dirty data in the rooster not captured by the clerk.
I created a rooster using a the first ten or so variables and then chucked away the rest meaning I took a rooster dictionary, truncated what I did not want, then edited my rooster from there. I further more re-used the same data sets as I needed the static data for household members.
The challenge is that on some slots where there is supposed to be blanks as nothing would have been entered, I get "dirty data" entered. This is causing quite a huge challenge when I export. How best can I use the Reformat Tool or any other for that matter to clean/ rid of dirty data in the rooster not captured by the clerk.