Hello, how can I join these 3 datasets so I can create a dashboard that shows me the necessary information.
Hi @Geral
you can either join them in the select statement or create 3 datasets and join them.
Looks like dmpa.asin = IT.asin and dmpa_merchant_customer = nm.merchant_customer_id
BR
Hi @ErikG I don’t know if I’m using an incorrect join, because it doesn’t throw me any data, what I need is the sales of table 1 and that it tell me the name of the asin that is obtained from table 2
Hi @Geral,
It’s been awhile since we last heard from you on this post, are you still encountering similar issues or were you able to find a work around?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @Geral - If all your tables are coming from the same database, you can create a custom sql and run it and avoid the join from QS as well. You can test the sql beforehand from any client tool to validate the output.
Regards - Sanjeeb