I have been trying to use multiple functions that would return an array instead of a single cell, and the result is always truncated to the first cell. The function in question is not relevant, even table references suffer the same fate.
PFA ss of two such instances.
bits_batchmates is an array reference, which should ideally return a table. bits_batchmates[States] should return the column States. Instead, it returns the single state value, Andhra Pradesh.
The return value for UNIQUE function
Array reference
Note: Although it must be mentioned that any reductive calculations on these arrays return the expected values.
I am using the flatpak version 7.4.0.163
I have been trying to use multiple functions that would return an array instead of a single cell, and the result is always truncated to the first cell. The function in question is not relevant, even table references suffer the same fate.
PFA ss of two such instances.
bits_batchmatesis an array reference, which should ideally return a table.bits_batchmates[States]should return the column States. Instead, it returns the single state value, Andhra Pradesh.UNIQUEfunctionNote: Although it must be mentioned that any reductive calculations on these arrays return the expected values.