Community & Support
Learn
Marketplace
Discussions
Categories
Discussions
General
Platform
Academic
Partner
Regional
User Groups
Documentation
Events
Altair Exchange
Share or Download Projects
Resources
News & Instructions
Programs
YouTube
Employee Resources
This tab can be seen by employees only. Please do not share these resources externally.
Groups
Join a User Group
Support
Altair RISE
A program to recognize and reward our most engaged community members
Nominate Yourself Now!
Home
Discussions
Community Q&A
Changing table structure through pivoting
Salo
I am a student new to Rapidminer may be missing something but I have the following simple data set
ID | DESCRIPTION
21033207| AMIGDALECTOMIA COM ADENOIDECTOMIA
21033207| MIRINGOTOMIA COM INSERCAO DE TUBO
21033209 | OPERACOES NO VITREO NCOP
21033209 | INJECCAO DE SUBSTITUTO DE VITREO
21033209 | REPARACAO DE DESCOLAMENTO DE RETINA COM DEPRESSAO ESCLERAL E IMP
21033209 | INSERCAO PROTESE INTRAOCULAR CRISTALINO SUCEDENDO A EXTRACCAO CA
21033209 | FACOEMULSIFICACAO E ASPIRACAO DE CATARATA
Each description corresponds to a surgical procedure, My original intention was to create a new column saying if it was performed (alway saying yes) and then pivot it and replace the missing values with No so I could have some thing like this.
ID | AMIGDALECTOMIA COM ADENOIDECTOMIA | MIRINGOTOMIA COM INSERCAO DE TUBO | INJECCAO DE SUBSTITUTO DE VITREO|etc...
21033207| Yes | Yes | No
If I do that I only get a single column with and ID and other just saying Yes, I can see the logic behind that result but then how would I obtain the column I suggested?
Find more posts tagged with
AI Studio
Accepted answers
All comments
Salo
Nevermind found it, I just had to uncheck the "skip constant attributes button"
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups