how to transform a nested list into a flat list

AppSheet AppSheet Q&A
1

in a table I have a start date column which is called [From] of type Date and another end date column which is called [To] of type Date, in the same table I have a column virtual which contains the list of all the dates between [To] and [From] which is called [ExtraitDate], I want to create a list of dates from the column [ExtraitDate] to use it in the WORKDAY() function , but with this formula WORKDAY(MAX(Select(Register of RDS booklets[Date_Derniere_Feuille],([Unite]=[_THISROW].[Unite]))), 21, ListePedago[ExtraitDate]) I have this error, WORKDAY has invalid inputs. Parameter ListePedago[ExtraitDate] has the wrong element type: List

2

SPLIT((“” & (ListePedago[ExtraitDate] - LIST(DATE(“”)))), " , ")

1 Like
3

I have this error message, Arithmetic expression ‘(ListePedago[ExtraitDate]-LIST(DATE(“”)))’ cannot convert ‘List of Date’ to ‘List of List of Date’

1 Like
4

Whoops! Try this instead:

SPLIT((“” & (ListePedago[ExtraitDate] - LIST(“”))), " , ")

5

Arithmetic expression ‘(ListePedago[ExtraitDate]-LIST(“”))’ cannot convert ‘List of Text’ to ‘List of List of Date’

1 Like
6

OK. How about just this?

SPLIT((“” & ListePedago[ExtraitDate]), " , ")

7

WORKDAY(MAX(Select(Registre des livrets RDS[Date_Derniere_Feuille],([Unite]=[_THISROW].[Unite]))), 21, SPLIT((“” & ListePedago[ExtraitDate]), " , "))

error : WORKDAY has invalid inputs. Parameter SPLIT(CONCATENATE(“”,ListePedago[ExtraitDate])," , ") has the wrong element type: Text

8

Wow! OK, so let’s try this, then:

(LIST(DATE(“”)) + SPLIT((“” & ListePedago[ExtraitDate]), " , “) - LIST(DATE(”")))

9

I created a new virtual column with this code, UNIQUE(SPLIT((“” & ListePedago[ExtraitDate]), " , ")) and I inserted the column in the code, WORKDAY(MAX(Select(Registre des livrets RDS[Date_Derniere_Feuille],([Unite]=[_THISROW].[Unite]))), 21,[ListDatePed])

and everything works perfectly, thank you

1 Like