The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

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

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 RM Data Scientist
    Hi,
    sounds like the transpose operator is your thing.
    BR,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • 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

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

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