Options

Convert Column Data to Row

sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
in Help
Hello ,
I have 
Data:
Value                             Attribute
?
Count
4.0
MONTH
15.0
WEEK_OF_YEAR
2022.0
YEAR
1633.1286847639503
prediction(Count)
?
Count
4.0
MONTH
16.0
WEEK_OF_YEAR
2022.0
YEAR
1674.7535102732875
prediction(Count)
Expected output
Count MONTH WEEK_OF_YEAR YEAR prediction(Count)
?          4.0         15.0                        2022 1633.128   

Can anyone help me on this

Answers

  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,507 RM Data Scientist
    Hi,
    sounds like the transpose operator is your thing.
    BR,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Options
    sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
    edited June 2022
    mschmitz Attribute values repeating after 5 entries i want all in row-wise only one header

  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,507 RM Data Scientist
    Then Transpose and Append?

    BR,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.