Reference two tables from one column and virtual column

[Simon1]

I have a Product column from which I’m referencing a table, Product Info 2
I’ve added a virtual column, Product Image ref, which takes the value from the Product column and then references another table, Product image url.csv

When I save it works on the emulator and in the app on another device, but when I go into the Product Image ref column it gas changed to reference Product Info 2.
Then if I save again I get the error, Unable to find column.

I’m sure I’ve done virtual ref columns using values from other Ref columns before.
Is this s new bug?

[Steve]

Simon:

Is this s new bug?

I doubt it, but tough to say without seeing the details of your virtual column, at least.

[Simon1]

Here is the virtual column details

I save it like that, but then the source table changes after I’ve saved it
I made a video of it happening, which might clarify

[Steve]

Please post the configuration displayed when you click View Definition:

[Simon1]

Nothing shows when I click that

[Steve]

In Data > Tables, does there exist a table name Product Image url.csv? If not, is there a slice of that name in Data > Slices?

[Simon1 · Accepted solution]

Yes, Product image url.csv in is the tables.
I’ve got round it by making a virtual column, Product Text, as type Text using the value from the Product column.
Then another virtual column type Ref taking the value from the Product Text column.

This way the Ref table stays as I want it.

It seems that if a virtual column is a Ref and it just uses the value of a column which is also Ref it wants it to match the table as well.