Map Storage Type and Window Visual Recipies

[tgb417]

I've been working with standard local CSV files as datasets rather than database-connected data sets recently.  In doing this I've run into a problem with the window recipe.  On simple data types I can "retreive" a column.  However, for the “map” data type the button to retrieve the column that is of type map is grayed out.

anyone know why this is?  Is there a work around?

Image: Window recipe grayed out [retrieve] button for just the variable to type Java map.

[ZachM · Accepted solution]

Hi @tgb417,

I was able to reproduce this issue on my end using DSS 11.0.1. It appears to be a limitation of visual-recipe aggregations. They only support basic types (string, int, double, boolean, date).

You can work around the issue by manually setting the type of the affected column to "string" in a Prepare recipe before the Window recipe:

I also logged this as a feature request on your behalf for further review and consideration by our product team.

Thanks,

Zach

[tgb417]

@ZachM 

Thanks for the insights and work around.