How to add rows in between a field(column)

[Thulasi]

A

B

C

D

Above is the existing field

A

Z

Y

X

B

C

and that above field will be mixed with some other data. Its nothing but adding rows(in middle) in particular column. How to solve this?

Thanks

[SophiaF]

It sounds like the Generate Rows tool would be the way to go

[jrgo · Accepted solution]

Hi @Thulasi,

Alteryx can stack 2+ data sets together using a Union tool, but your data has to have some other data point that can tell Alteryx (or any analytical tool) where to position it.

However, if that additional data you need should always be added after the first record, then you can split it up and then stack/union it all back together. I've attached a workflow that explains this approach and the screepcap below highlights the important detail within the Union tool in order to make this work.

 

I hope this helps, or, at minimum, gives you some additional ideas to approach your use case.

Best,

Jimmy