Changing levels' names
Posted: Tue Apr 01, 2025 6:36 pm
Hi,
I'm trying to attribute other names for the levels.
As you can see in the image, I want to change both "Concordo ligeiramente" and "Concordo totalmente" to "1". However, it seems that I cannot do this without appearing a (2) for repeated names.
A possible solution is to create a computed variable for this column using the rule IF( AQ_01 == "Concordo totalmente" or AQ_01 == "Concordo ligeiramente", 1, 0). However, I want to avoid adding more columns to my database unnecessarily.
I also tried to change the Measure type from Nominal to Ordinal, and the Data type from Text to Integer, but all the values disappeared.
Does anyone know why this is happening and how can I change the name of the two levels to the same without the (2)?
I'm trying to attribute other names for the levels.
As you can see in the image, I want to change both "Concordo ligeiramente" and "Concordo totalmente" to "1". However, it seems that I cannot do this without appearing a (2) for repeated names.
A possible solution is to create a computed variable for this column using the rule IF( AQ_01 == "Concordo totalmente" or AQ_01 == "Concordo ligeiramente", 1, 0). However, I want to avoid adding more columns to my database unnecessarily.
I also tried to change the Measure type from Nominal to Ordinal, and the Data type from Text to Integer, but all the values disappeared.
Does anyone know why this is happening and how can I change the name of the two levels to the same without the (2)?