Alteryx equivalent to SAS Array?

[Karamazov]

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";

R1	R2	R3	R4	R5	R6	R7	R8	R9	R10	Result
XXBNVXX	XXDEFXX	XXABCXX	XXUGTXX							Low
XXBNVXX	XXDEFXX	XXGHIXX	XXUGTXX	XXLKJXX						Not Defined

[apathetichell · Accepted solution]

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.

[Karamazov]

Thanks - been able to get what I needed using summarise and multi-row formulas