Create a list of values given some strings fields

[DamianoD]

Hi everyone,

I have declared a variable as following:

LET vDateSelected = KeepChar($(id_date),'0,1,2,3,4,5,6,7,8,9')

This vDateSelected extracts all parameters passed by ODAG implementation on id_date field.

If i select two dates, such as 20200201 and 20220303 in Selection Template, the Trace vDateSelected =$(vDateSelected); command will give me: 20200201, 20220303.

User can select multiple dates, and I need to extract YearMonth format from all the dates passed; is there any way to load dates given by user in a list whom I could check after?

Thanks,

Damiano

[henrikalmen]

This should (probably) give you a table with one row for each date (in string format) in the variable (the column name becomes selected_date), if that is what you want? (If autogenerate(1) doesn't work in this context there are other solutions...)

DateSelected: LOAD subfield('$(vDateSelected)', ',') as selected_date autogenerate(1);

Note that your keepchar criteria can be written like this: '0123456789,' (you need to incoude a comma in the string, but you don't need to separate the values with commas).