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.
De-pivot excel file [SOLVED]
I am trying to de-pivot a excel file like below, the "NA" are null values, I have Field3 and field4 set as integers
I have:
attribute name >> edit list >> attribute name = field3 & atrributes = .*
index attribute = myNewFieldName
checked create nominal index
checked keep missings
I keep getting the error:
Thanks
I have:
attribute name >> edit list >> attribute name = field3 & atrributes = .*
index attribute = myNewFieldName
checked create nominal index
checked keep missings
I keep getting the error:
Any help is greatly appreciated
Process failed
"attributes have different value types: no conversion performed"
Thanks
id field1 field2 field3 field4 |
1 stuff aaa 4 3 |
2 stuff bbb 7 6 |
3 stuff ccc NA 1 |
4 stuff ddd 3 3 |
5 stuff eee 9 NA |
6 stuff fff 6 NA |
Tagged:
0
Answers
Best regards,
Marius
I need,
id field1 field2 Cnewfeld Col5
1 stuff aaa field3 4
1 stuff aaa field4 3
2 stuff bbb field3 7
2 stuff bbb field4 6
3 stuff ccc field3 NA
3 stuff ccc field4 1
4 stuff ddd field3 3
4 stuff ddd field4 3
5 stuff eee field3 9
5 stuff eee field4 NA
6 stuff fff field3 6
6 stuff fff field4 NA