Hi Josh, thank you for your reply!
I did create a hosted feature layer using the Join Feature; however, the issue I ran into was that the resulting hosted feature layer is unable to automatically update to display new data (from the two separate tables, which receive data from active Survey123 form).
I am wanting to find a way to produce the same result as the above, but a feature layer containing a joined dataset that gets automatically updated when the two source tables receive new data. The purpose of the new feature layer is to be used in ArcGIS dashboard for creating charts containing data from the two different source tables (sublayers).
I've added a sample data - the screenshots show one table named 'Time Searched' (a repeat), and another table named 'Bird found' (also a repeat). These are dataset outputs directly resulting from a Survey123 form. The form respondents are are able to either enter data for Time Searched, or Bird Found, depending on a selection at the beginning of the survey - bird isnt found every search period, so Time Searched data is input separately to Bird Found.
In a Dashboard displaying the resulting data, I need to create a chart that shows the sum of minutes searched and the number of birds found by each person. In the current format this is not possible to create, as the 'Minutes searched' is in the Time Searched sublayer while the birds found data is in the Bird Found sublayer, and Dashboard only allows selection of one sublayer. So I would like to join the features in these tables together into one feature layer, which would show up as one layer containing data from both tables, to select in the Dashboard. However, the new feature layer needs to be able to update automatically, so that the Dashboard shows real-time live information.