Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

Data from long to wide format

windswinds Member Posts: 4 Contributor I
edited November 2018 in Help
I have some data I get from a SQL query like this:

[tt]Group    Value
1            12
1            14
2            23
2            24
...
[/tt]

and I'd like to output it to a file like this:

[tt]1    12,14,...
2    23,24,...
[/tt]

How can I do this with RapidMiner?

Thanks.

Answers

  • SebastianLohSebastianLoh Member Posts: 99 Contributor II
    Hi winds,

    what you are looking for is the Pivot operator. Search for "pivot" in this forum and especially in the the Community Extension (View -> MyExperiment Browser) and you will find several examples how to use it.

    However, you'll need an index/item  attribute, eg.

    Group    Value  Index/Item
    1            12          1
    1            14          2
    2            23          1
    2            24          2
    ...

    Ciao Sebastian
Sign In or Register to comment.