How to combine two slices data and display as single data

[deepak_patel]

i have a table Account Master and second table Transaction with column ID,Date,CreditID,DebitID,Note,CreditAMT,DebitAMT,CreditBalance, DebitBalance.
i have two slices from this table ,one with ID,CreditID,CreditAMT,DebitAMT, CreditBalance, other with ID,DebitID, CreditAMT,DebitAMT,DebitBalance. i want to combine these two slices and want to get data as single table for AccountID for ledger record. how can this possible ?

[LeventK]

Nope, you can’t.
@Steve can you please re-tag this post as Question at your convenience? Thnx.

[MultiTech]

The only way to accomplish something like this would be to create a third table, which contained matching columns between the other two tables, and then populate that third table with your combined records.

It’s a duplication of data, not really something that should be done as standard procedure, but it would accomplish what you’re looking for.

---

@deepak_patel have you checked out references? You can connect your transactions table to the account table using a reference, then you’ll see a list of all related transactions per account.

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.