Getting unique IDs from API data (where identifiers repeat)

[shunter04]

Hi All 

I am new to Alteryx and have been playing with some data before getting stuck. I have a download of directors details from Companies House. 

I have used text to columns to split the JSON_Name data, extracting the numerical identifier. However, this identifier repeats every 100 records and I am struggling to assign another unique id (one ID per every c.10 rows) that will allow me to cross tab the data correctly?

[JosephSerpis · Accepted solution]

Hi @shunter04 I mocked up an approach to tackle this. Let me know what you think?