Formula Help

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!

Workflow

Datasets

Help

Expression

Accepted answers

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

PreviousLetter.yxmd

All comments

Hi @analyzer222 ,

What do you mean by comparing series ?

Cheers,

Jean-Baptiste

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.

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

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

PreviousLetter.yxmd

Essentially yes, but in 2 different columns.

Thanks Dan! That worked.

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703