Depivot multiple attributes Help
Pennoca
New Altair Community Member
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,
Tagged:
0
Answers
-
It sounds like your RegEx when you add another variable is overlapping.
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.0