Alteryx equivalent to SAS Array?

Question

Hi - Hope someone can help

I'm just starting the process of moving away from SAS to start using Alteryx and the one element of SAS functionality I'm having trouble replicating in Alteryx is the array statement

More specifically I need the ability to scan the values held in the same row for defined set of columns (i.e. R1 to R10 below) and create a new column based on a conditional query so the output would be as below

For anyone familiar with SAS I'd be writing

array search R1-R10;

do i = 1 to 10;

if substr(search(i),3,3) = 'ABC' then Result = 'Low';

end;

if Result = "" then Result = "Not Defined";

R1R2R3R4R5R6R7R8R9R10ResultXXBNVXXXXDEFXXXXABCXXXXUGTXX      LowXXBNVXXXXDEFXXXXGHIXXXXUGTXXXXLKJXX     Not Defined

apathetichell · Accepted Answer

you'd need to transpose/summarize (and concatenate the fields) to do this. That effectively creates a summary field of the values in those fields which you can execute a CONTAINS on (for string matching) or an IN on (for distinct value matches). For an IN your summarize tool concat config is key.