Union Tables like SQL. I wonder if there is ...

[Koichi_Tsuji]

Union Tables like SQL.

I wonder if there is existing functions within Appsheet to “union tables” alike SQL available or not.

What I’m trying to do is to create multiple virtual table (slices) out of single table which is uploaded to Appsheet, then union those slices to make a single virtual table.

For instance, 1st virtual table contains ID + Image 1, and second one contains ID + Image 2 and so on.

On my case, there is single table, contains multiple images as part of column. Slice this table so that each virtual table contain just one images and then union virtual table after that.

Originally one table contains various number of pictures within a single row. By doing this, i can convert this table which contain single column (image) with unique ID, but it turns to be multiple rows.

This is simplified data schema.

(original) table

ID

/

Image 1

/ Image 2

/

Image 3

/

Image 4

/ Image 5 xxx

xxxxx

xxxxxxx

xxxxxxx

xxxxxxx

xxxxxxx xxx

xxxxx

xxxxxxx

xxxxxxx

xxxxxxx

xxxxxxx

(after union) ID

/

Image xxx

xxxxxx xxx

xxxxxx xxx

xxxxxx xxx

xxxxxx xxx

xxxxxx xxx

xxxxxx xxx

xxxxxx xxx

xxxxxx xxx

xxxxxx xxx

xxxxxx

What im doing now is to do this works within google spreadsheet, using QUREY() and Importrange() functions.

This create additional physical files which is not ideal and slow down APP response as well.

Again, wondering if we can achieve this within Appsheet?