Hi forum,
Actually I'm too new with RapidMiner but with quite some experience using Python.
The problem that I'm facing is that I have a file with data in this form:
Column Value
ContextDataValuesAgeValue 55to64
ContextDataValuesGenderValue Female
ProductId cb4d59cf-c48d-47ef-a943-50b2ae5d01ee
Rating 5.0
RatingRange 5.0
SubmissionTime 2016-09-14T14:39:14.000+00:00
UserLocation Southport, United Kingdom
ContextDataValuesAgeValue 45to54
ContextDataValuesGenderValue Female
ProductId cb4d59cf-c48d-47ef-a943-50b2ae5d01ee
Rating 5.0
RatingRange 5.0
SubmissionTime 2017-11-10T09:31:42.000+00:00
UserLocation London
What I need to do is to create a new file with each one of the "columns" and their corresponding value in one row for each group of columns. In this example I wrote 2 "groups" or new rows.
I have tried the PIVOT component but because the labels (text) of the Columns are the same (repeated in different rows) it throws an error of "Column name already exists". I also tried the Loop component but I don't know how to tell it "process the first 7 rows, pivot them, generate a new Example (row) and continue gropuing the rest of the file". I know is pretty simple but really can't find the way to do it.
I really appreciate all the help with this.
Thanks in advance!