Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.
Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community
03-21-2018 05:25 PM - edited 03-21-2018 05:28 PM
I have a table of IDs to Names:
id: name
1: user1
2: user2
3: user3
and another table of more data:
id: edu : ......
1 : bachelor : ....
2 : master : ....
3 : phd : ....
Is it possible to use AQL to join these two together so I can display the name corresponding to an id in a search?
04-17-2018 10:01 AM
No, I do not have an EUM license. I was asking for Analytics tables in general.
How should we structure a search to select from multiple tables? Do they need to share the exact same rows, or just a subset?
04-19-2018 11:24 PM
Hi Kyzhou,
As you don't have an EUM license hence this 401 error you see. You need to have EUM license to use browser_records and synth data.
Now regarding your original query we can not select data to be shown from multiple tables unless they are from the same schema. Iff two tables that you are trying to see are in the same schema can you structure a query to fetch data combining both, but not in any other case.
Hope that clarifies. Do let me know in case you have further queries.
Thank You,
Chitra
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 |
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form