Map Storage Type and Window Visual Recipies

tgb417
tgb417 Posts: 1,649 Neuron

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.

Tagged:

Best Answer

  • Zach
    Zach Posts: 153 Dataiker
    Answer ✓

    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:
    E32D8601-5640-4FA7-B2C0-B565C892D32C_1_105_c.jpeg

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

Answers

Setup Info
    Tags
      Help me…