BUG in SPLIT function when used in a Virtual Column

[MiguelPilo]

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 · Accepted solution]

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.

[MiguelPilo]

Perfect, I get it! Thanks for the solution.

What still i don't understand is why expression result from Test show me it as a correct and also the values had correct written to a pdf file created by a bot.

[WillowMobileSys]

That is an oddity and I am not certain why.  I have seen several inconsistencies in the Test results that I typically ignore them.