Slice and tables questions

[Web_Master]

Hello

I have the need of creating an slice with information from two different tables. Is that possible?

I am also wondering if I can get the information from does two tables automatically on a new table without the need of using the form.

[Kirk_Masden]

In my experience, data can be split fairly easily on AppSheet using the “slice” function but I doubt that merging is possible. I wonder if you might not be better off having all of the data in one table and then splitting it up as needed with slices instead of starting with separate data and trying to merge it later.

I’ll be interested to see if anyone can offer a good way to merge data as you indicate.

[Steve]

It is not possible to merge multiple tables using a slice. @Kirk_Masden’s suggestion of using a single table for all the data and using slices to separate it is a good one if your data is structurally compatible.

[Web_Master]

Web_Master:

can I get the information from does two tables automatically on a new table without the need of using the form.

is this posible?

[Steve]

You’d have to use the API, or do it outside of AppSheet.

help.appsheet.com

API: The Essentials

How to use the API to make changes to your app.

[Mike_A]

@Web_Master - I often do this at the source data level (outside appsheet). In my case, I may have two google sheets that I use QUERY to join the data as I want it. THEN, appsheet can consume it easily…

InfoInspired – 22 Aug 17

Consolidate Data from Multiple Sheets Using Formula in Google Sheets

You can consolidate data from multiple sheets using formula. We can use the Query function in Google Sheets to combine multiple sheets and consolidate data.