Solved: BUG in SPLIT function when used in a Virtual Colum... - Page 2

MiguelPilo · 07-23-2024 01:22 PM

Virtual column do not recognize SPLIT function and returns balnks.

When I "Test" the formula for this virtual column, the expresión result is correct even results are correct in a file generated by a bot. But in the app and in preview data virtual column is empty.

WillowMobileSys

SPLIT requires a text string to operate on. The SELECT returns a LIST.

Since it appears you are dealing with a List of Lists, try using this expression instead:


UNIQUE(SPLIT(CONCATENATE(SELECT(PRYECTOS[List de BD]...))))

The CONCATENATE flattens the list returned from the SELECT into a single text string. The SPLIT then re-creates a LIST from that string expression. And of course UNIQUE will eliminate duplicates.

View solution in original post

BUG in SPLIT function when used in a Virtual Column