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.
Depivot multiple attributes Help
Hi All,
How can I depivot a table that has numerous groups with each group having multiple attributes in the same new created attribute?
I managed to depivot a group of attributes containing a certain characters, but I would like to depivot in the same way another group of attributes. I tried to add entry in the attribute name edit list by having the same new created attribute name but it does not work...problem occur cannot create nominal index cannot be used...
Anyone know how to do this?
many thanks,
Hi All,
How can I depivot a table that has numerous groups with each group having multiple attributes in the same new created attribute?
I managed to depivot a group of attributes containing a certain characters (SM.*), but I would like to depivot in the same way another group of attributes. I tried to add a new entry in the attribute name edit list by having the same new created attribute name but it does not work...problem occur the value true for parameter create nominal index cannot be used...more than 1 series listed in attribute name. If I then unselect the create nominal index..it retrives a message: process failure series must have the same lenght, no conversion is performed..
Anyone knows how to do this?
many thanks,
How can I depivot a table that has numerous groups with each group having multiple attributes in the same new created attribute?
I managed to depivot a group of attributes containing a certain characters, but I would like to depivot in the same way another group of attributes. I tried to add entry in the attribute name edit list by having the same new created attribute name but it does not work...problem occur cannot create nominal index cannot be used...
Anyone know how to do this?
many thanks,
Hi All,
How can I depivot a table that has numerous groups with each group having multiple attributes in the same new created attribute?
I managed to depivot a group of attributes containing a certain characters (SM.*), but I would like to depivot in the same way another group of attributes. I tried to add a new entry in the attribute name edit list by having the same new created attribute name but it does not work...problem occur the value true for parameter create nominal index cannot be used...more than 1 series listed in attribute name. If I then unselect the create nominal index..it retrives a message: process failure series must have the same lenght, no conversion is performed..
Anyone knows how to do this?
many thanks,
0
Answers
You can't (as an example) have a group like
SM.*
and then another as
.*
because the first attribute will group all matches to SM.* together and then the second attribute will get upset because .* wants to use those values too.
Check out one of my other posts in the forum for depivot. I think I posted an example process with two variables.