Formula Help

[analyzer222]

I have a set of data where I am trying to compare the current Series letter to the previous one.

Example, Series C, I only want to compare to Series B, but I don't need Series A.

What formula can I use in the Formula tool to pull back that information?

Thanks!

[Jean-Balteryx]

Hi @analyzer222 ,

What do you mean by comparing series ?

Cheers,

Jean-Baptiste

[analyzer222]

Hi Jean-Baptiste,

Series is just 2 columns I have in my dataset.

Essentially they are like Record IDs, but in Alphabet letter order.

Example - I want to compare the current record (letter S) to the previous record (letter R) but the data pulls in all previous records (letters A to R). I want to limit the data to only display the record for letter R, so I am trying to use the Formula tool to do that.

Hope that makes sense.

Thanks.

[Jean-Balteryx]

Let's say you have only one column with alphabet letter. You want to compare one letter with the one in the previous row ?

[danilang · Accepted solution]

Hi @analyzer222 

You can use the CharToInt/CharFromInt formulas to find the letter that precedes another

CharFromInt(CharToInt([Series])-1)

CharToInt converts the letter to its corresponding ASCII value.  Subtract 1 and convert back to a letter with CharFromInt

Join to Series2 using [PrevSeries]

Dan

[analyzer222]

Essentially yes, but in 2 different columns.

[analyzer222]

Thanks Dan! That worked.

I'm still new to Alteryx and that was a simple solution 😀