How to restrict all columns (not column) to specific datatype in the parameter

Options
sth-dss
sth-dss Partner, Registered Posts: 1 Partner

Hi DSS community,

I am in the process of developing a widget, and one of my parameters needs to be of type "COLUMNS", but restrict ALL data types to only be numeric (["tinyint", "smallint", "int", "bigint", "float", "double"]). I know this is doable for a single column parameter ("COLUMN") by using the argument "allowedColumnTypes", however when I try to do this for my "COLUMNS" param, it only produces the desired warning message for the first column. For any others, it does not return a message, even if a non-numeric is selected.

Does anyone know a way around this?

Thanks in advance,

Sophie

Answers

  • Sarina
    Sarina Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer Posts: 315 Dataiker
    Options

    Hi @sth-dss
    ,

    Thank you for the question! Your finding is currently correct - the allowedColumnTypes option does not apply to multiple columns when using the type COLUMNS. Instead it indeed will only apply to the first selection. This is noted and currently in our backlog.

    Thanks,
    Sarina

Setup Info
    Tags
      Help me…