Hallo, I hope ask my question in the right forum. Im not a data analyst. So I have only a small knowledge. I have a data analysis tool for that I need lucency query language. Simple query I can do. But I don't know how to define a query with conditions.
My dataset looks like: Transactions from customers. Each transaction the customer can only buy 1 item. The datable looks like that:
Customer Produkt Price Date
1 A 10$ 01.01.2017
1 B 12$ 01.02.2107
2 C 8$ 03.04.2017
3 B 12$ 23.06.2017
The query which im searching for has to show the result: all customers who have bought product A and produkt B in the last year.
The problem is if I I ask produkt: A AND Produkt B than it shows me the sum (customer 1 and customer 3) and not only the customers who have bought both. The result I want to have is only customer 1.
Can somebody help me?
I would appreciate an answer very much!
Kindly regards
Jenny
Hi
What version of Alfresco are you using?
What data analysis tool are you using and how are you using it with Alfresco?
Andy
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.