Generate rows (text interval)

[mikaelhyensjo]

Hi.

I have a table with intervall by product group (from CYOBJA and to CYOBJB) and the grouping name is GAC.

Tried to use the generate rows to create one unique row per ID with no success.

Possible to solve simpel in SQL but how to do in Alteryx?

[Inactive User · Accepted solution]

You can use the unique tool to create unique rows and then either use those rows or union them back into the original set if that is what you are trying to accomplish.

[JoshKushner]

If you're trying to create record ID's for each unique ID the you'll want to use the multi row tool. Not totally sure about the question though. Does my or Ryan's answer address it?