Union of values ​​with Record, grouped by

[ai-trojan]

Hi guys,

I hope everyone is ok. I come in search of wisdom and know-how,

I explain, I am making a union between a created value ("Core_"), the ID and the RecordID.

I am currently receiving the Record from 1 to N. However, what I need is to generate the Record from the number of IDs that exist.

For example, if I have 6 IDs grouped into 2 unique values, I should get from 1 to 3 for each unique value, at the moment I am not achieving it.

I share what I currently have,

The first image is what I have now and the second image (helped with paint haha) is what I should get.

Actually Output

Expected Output

Thanks!

Miguel Ángel

[binuacs · Accepted solution]

@ai-trojan One way of dong this with the multi-row tool

Multi-row tool configuration

[ai-trojan]

Thanks for unlocking this!