I have a key column (USER) related with 4 different tables:
- USER on Activities 1
- USER on Activities 2
- USER on Activities 3
- USER on Activities 4
Now AppSheet has created 4 different REF_ROWS VC:
- REF_ROWS("Activities", "USER on Activities 1")
- REF_ROWS("Activities", "USER on Activities 2")
- REF_ROWS("Activities", "USER on Activities 3")
- REF_ROWS("Activities", "USER on Activities 4")
How could I join all these 4 REF_ROWS tables into a new one and then delete them?
User | Count |
---|---|
34 | |
11 | |
3 | |
2 | |
2 |