Classify orders with the ordered products

DaHumma

Hey guys,

I'm new here and I have a little problem. I have a set of data where the UserID, the order number, the ordered articles and the articles gender (female, male, unisex). I want to see, for which gender the user buys products. Because i have one column per article, i want to compare the genders of those articles in the matching order number and generate a new attribute in which the whole order number get's the most bought gender in this order for the whole order number.
I tried to aggregate the order numbers and count the amount, a specific gender is in that order.
Now the problem is, how to generate the attributes, that match the order number, maybe you guys can help me?

Here is an example for the table:

UserID; ordernumber; article; gender

a; 10; 1234; female
a; 10; 1233; female
a; 10; 1245; unisex
b; 11; 1324; male
c; 12; 1324; male
c; 12; 1325; male
c; 12; 1223; female
d; 13; 1234; female
d; 12; 1245; unisex

kayman

Could you show the expected outcome in sort of dummy format? This way it's a bit easier to understand what you want to achieve.

DaHumma

Here's my xml description up until now:

<参数键= = " true " /“cache_process”价值>

<参数键= value =“group_by_attributes userid|ordernumber|brl_geschlecht"/>