indicator definition is flakey

[c...@evnbttr.com]

Hi... exploring Wizard and trying to create an indicator variable based on "COVID" being contained in one of 5 columns. I'm using "Any" and 5 "contains" conditions. However, as I build up the filter, it contains fewer matches with each condition I add, instead of catching more of the values. Is it choking on NULL values? Any workarounds? Thanks!

[Evan Miller]

Hi!

It's an interesting case, and as you suspect has to do with the NULL values. Right now a row in the Indicator is considered "Missing" if the same row in any of the condition columns is missing.

This behavior made sense in the old days when Indicator variables could only apply to "All" conditions. However, with "Any" flipped on, it creates unexpected results, as you saw. The only workaround right now is to ensure there are no missing values in the condition columns. I'll have a better solution in a future update.

Best

Evan

On May 6, 2020, at 18:59, c...@evnbttr.com wrote:

Hi... exploring Wizard and trying to create an indicator variable based on "COVID" being contained in one of 5 columns. I'm using "Any" and 5 "contains" conditions. However, as I build up the filter, it contains fewer matches with each condition I add, instead of catching more of the values. Is it choking on NULL values? Any workarounds? Thanks!

--
You received this message because you are subscribed to the Google Groups "Wizard User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to wizard-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/wizard-users/155e27e4-bc9a-4032-b4ad-00917360486b%40googlegroups.com.

[Cam Balzer]

OK thanks Evan! 

Is there a way to rewrite missing values in Wizard? Or is it better to do it before importing the data?

On Thursday, May 7, 2020 at 7:49:21 AM UTC-5, Evan Miller wrote:

Hi!

It's an interesting case, and as you suspect has to do with the NULL values. Right now a row in the Indicator is considered "Missing" if the same row in any of the condition columns is missing.

This behavior made sense in the old days when Indicator variables could only apply to "All" conditions. However, with "Any" flipped on, it creates unexpected results, as you saw. The only workaround right now is to ensure there are no missing values in the condition columns. I'll have a better solution in a future update.

Best

Evan

On May 6, 2020, at 18:59, c...@evnbttr.com wrote:

Hi... exploring Wizard and trying to create an indicator variable based on "COVID" being contained in one of 5 columns. I'm using "Any" and 5 "contains" conditions. However, as I build up the filter, it contains fewer matches with each condition I add, instead of catching more of the values. Is it choking on NULL values? Any workarounds? Thanks!

--
You received this message because you are subscribed to the Google Groups "Wizard User Group" group.

To unsubscribe from this group and stop receiving emails from it, send an email to wizard...@googlegroups.com.