In a custom export, "expand multiple options" shows "ghost columns"

Users
1

Hi all --

I am now making use of the feature in a custom export that will, for any
multiple-select question, output the results as expanded into
one-column-for-each-option.

Great feature.

However, when I ran the report just now, i saw that it also created new
columns for, apparently, some question options that are not existing in
that question. I am guessing that those question options are maybe
options that once existed before, but they have since been deleted or given
new labels. (correct me if that's not it.)

But right now, in my report, all of those "ghost options" are not showing
any 1's in them. all blank.

is there a way of deleting those ghost options somewhere (since their
actual options have long ago been deleted from the form itself)? OR, is
the idea that I would have to delete all of the forms that had been entered
when those items had been an option in the question, and then those columns
will disappear?

thx
eric

2

Hi Eric,

I am glad to hear you are enjoying that custom export feature!

Unfortunately, at the moment there is no supported way of deleting the
"ghost options". Since the list of options is built off of app builds,
deleting the forms would not help the columns disappear.

Let me know if you have any questions.

Thanks,
Robin Selwitz
CommCare Support

ยทยทยท On Wed, Nov 4, 2015 at 4:03 AM, Eric Stephan wrote:

Hi all --

I am now making use of the feature in a custom export that will, for any
multiple-select question, output the results as expanded into
one-column-for-each-option.

Great feature.

However, when I ran the report just now, i saw that it also created new
columns for, apparently, some question options that are not existing in
that question. I am guessing that those question options are maybe
options that once existed before, but they have since been deleted or given
new labels. (correct me if that's not it.)

But right now, in my report, all of those "ghost options" are not showing
any 1's in them. all blank.

is there a way of deleting those ghost options somewhere (since their
actual options have long ago been deleted from the form itself)? OR, is
the idea that I would have to delete all of the forms that had been entered
when those items had been an option in the question, and then those columns
will disappear?

thx
eric

--
You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.