Concatenate first and second value of an attribute
I have an example set with two attributes and two values. "Word" is nominal, "total" is numerical.
want to do the following: generate new attributes in which the first and the second value are concatenated and appear in the same row:
I will place this subprocess into a loop, looping over 240 example sets with different values for "word" and "total"; so I cannot use any fixed value for the concatenation, but need to identify the values I want to concatenate (which are of the same attribute) by their order (first_second).
I tried generate attribute but couldn't find out how to identify the values by their order. I also tried to transpose the whole thing which gave me an error because of duplicate IDs.
I spent the whole day searching for operators to solve this apparently simple process but did not yet find a solution. Maybe somebody has an idea on this?