I have a list of IDs for a table in CSV forma...

(Steven Aung) #1

I have a list of IDs for a table in CSV format.

What would be the most efficient way to retrieve a ref list?

Using SELECT with FIND function to match the table ID and the CSV text is very slow.

Is there a way to simply covert the CSV to a ref ID list without using SELECT?

(Tony Fader) #2

@Steven_Aung If it’s a virtual column, try changing the type of the column to be a list of table refs.