Alteryx Analytics Hub

Find answers, ask questions, and share expertise about Alteryx Analytics Hub.

MATCH_RECOGNIZE Pattern Recognition over Rows

terry10
11 - Bolide

I'm looking to do something analogous to MATCH_RECOGNIZE to identify sequences of rows that matches a REGEX-like pattern (i.e., regex matching over rows). I'm wondering if this type of pattern recognition can be done in Alteryx, perhaps using the multirow formula tool with regex functions. Has anyone tried?

 

Snowflake MATCH_RECOGNIZE 

Presto/Trino MATCH_RECOGNIZE

Oracle MATCH_RECOGNIZE

Teradata Aster NPath



3 REPLIES 3
terry10
11 - Bolide

P.S. I wasn't sure which board to post this question in. Should I have posted it on a different board than the Analytics Hub?

Chantelb
9 - Comet

Hi @terry10 ,

 

You could maybe use the REGEX_Match function with a Multi-Row Formula tool or just an regular formula tool. Would you have an example?

 

Cheers,

Chantel

terry10
11 - Bolide

@Chantelb 

 

Yes, that's along the lines I was thinking, but I wondered if anyone had already worked through it. There are examples available on the links I included above. 

Labels