Replace the "Table" section of a SELECT expression with different values

AppSheet AppSheet Q&A
1

Good morning everyone,

Is it possible to change the table section of a SELECT expression with different values? I thought something like:

SELECT(TEXT([_THISROW].[Tables])[EntryID], …

It saves from creating a SELECT for each of the values in the Table column. It does not seem to work. Any other way to do this?

Thank you,

Hyman

2

Capture.JPG
Capture.JPG659×256 22.7 KB

I don’t think it’s possible because the ‘from-dataset’ is the RAW identification of a table’s name or slice’s name, any expressions would not be allowed here.

1 Like
3

Ok, I also didn’t have much hope that it would be possible.

Thank you

1 Like
4

Hmmmm… Are your tables that similar to the degree you could confidently use the very same SELECT() expression on all of them and be as much confident about the returned results? In that case, possibly, you didn’t need to have as many separate tables in the first place.

2 Likes
5

I hear you and I did consider that…but it is a long story : )

Thank you for the advice.

1 Like