Hello, this might be super simple but I'm stuck and I'd really appreciate a helping hand 😄
I have an API that has two queries producing similar results. Example:
Query 1: User ID / Amount
Query 2: User ID / Amount
On each query I have aggregated the results by User ID to sum the amounts, and I have then merged the results of Query1 and Query2 in a variable. However, there are some users that are in both Query 1 and Query 2, meaning that they appear two times in my merged variable. What I need is to aggregate that variable so I only have one User ID for each user, and one total amount. What is the easiest way of doing this?
Thank you in advance!