nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

611076_en-US

liliconcom

Find the longest repeating pattern

Hi,

Can somebody explain how to find the longest repeating pattern in a column?

For example, let's suppose I have the following table:

Screenshot 2023-03-13 at 11.40.35.png

The pattern with the largest size is: "1 5 6 8 7", and it occurs 3 times in this column. Notice that there is another pattern in the table ("1 5 6"), which occurs 5 times, but is not the largest.

I tried with Screening - Explore patterns, and although it return which values are most duplicated, I can't get the exact pattern. Or multiple patterns, with the number of occurrences.

Maybe there is some option I should enable? Or should I use some other platform? Or if somebody can help me out with a JSL script.

Thanks

Data Table

Scripting

Comments

There are no comments yet