Reverse the direction of the likert scale on negative numbers.

[Riot]

I am looking to reverse the direction of the likert scale on all variables that had negative = high
for consistency so that positive = high across all variables

I am basically looking to move some things from R-code to Alteryx. 

The R-Code looks like this: 

WholeClean$Variable1 <- max(WholeClean$EDANX01, na.rm=TRUE) - WholeClean$Variable1 + 1
WholeClean$Variable2<- max(WholeClean$EDANX02, na.rm=TRUE) - WholeClean$Variable2 + 1
WholeClean$Variable3<- max(WholeClean$EDANX03, na.rm=TRUE) - WholeClean$Variable3 + 1

Any idea where to start ? 

[MarqueeCrew]

If you give me a sample input and output is be happy to help. 

[Riot]

So basically, Let's say I have a variable, INT, and it measures Awarkdness  So I have several rows and Awakwardness is ranked 1-10 with 1 beaing really awkward and 10 being not awkward. 

I want to find a way to make 10 be really awkward and 1 be not awkward. Does that make sense ? 

[AndrewW]

Could you just multiply you awkwardness variable by -1?

[MarqueeCrew · Accepted solution]

This module will assign values on a 1-10 scale the values of 10-1.  Null Values on input remain NULL.

Thanks, 

Mark

[Riot]

Thank you. Out of curiousity, a few of the cleaning things I have to do involve shrinking the scale such as 

WholeClean$global07[WholeClean$global07 == 0] <- 1

WholeClean$global07[WholeClean$global07 == 1] <- 1.4

WholeClean$global07[WholeClean$global07 == 2] <- 1.8

WholeClean$global07[WholeClean$global07 == 3] <- 2.2

WholeClean$global07[WholeClean$global07 == 4] <- 2.6

WholeClean$global07[WholeClean$global07 == 5] <- 3

WholeClean$global07[WholeClean$global07 == 6] <- 3.4

WholeClean$global07[WholeClean$global07 == 7] <- 3.8

WholeClean$global07[WholeClean$global07 == 8] <- 4.2

WholeClean$global07[WholeClean$global07 == 9] <- 4.6

WholeClean$global07[WholeClean$global07 == 10] <- 5

Is it possible in this method? String values seem to remove the decimal. 

[MarqueeCrew · Accepted solution]

Hi @Riot

I modified the Likert module to demonstrate a BETWEEN function.  I setup a table with the maximum and returned value (e.g. -1 gets 0) and test for each value range.  See if this helps solve the problem in your reply.

Thanks,

Mark

[VizED]

How would I use the workflow above to reverse the likert scale for just a specific group of questions (5 or 6 of them).

Thanks!