topic Re: Shifting data in one column down by one cell in Alteryx Designer Desktop Discussions

Shifting data in one column down by one cell

SureshBurra1982 — Tue, 19 Jan 2021 05:37:14 GMT

Hi,

I have one column where I need to shift only that column to one cell down.

Input

Output

Re: Shifting data in one column down by one cell

SureshBurra1982 — Tue, 19 Jan 2021 05:40:37 GMT

Sorry Input is below

Re: Shifting data in one column down by one cell

Tyro_abc — Tue, 19 Jan 2021 06:54:53 GMT

This is my try, please check..

Re: Shifting data in one column down by one cell

SureshBurra1982 — Tue, 19 Jan 2021 07:00:37 GMT

I have tried this one. This is moving the data one cell down but it is keeping the original data as it is. Can we have anything to move data one cell down with out keeping the original data as it is.

Re: Shifting data in one column down by one cell

AngelosPachis — Tue, 19 Jan 2021 07:08:56 GMT

Hi @SureshBurra1982 ,

You can do than by offsetting that original C2 column by one cell, essentially pushing everything a place downwards.

I used the generate rows tool to generate that single null cell and then unioned it at the top of the Old C2 column. Then bringing back the two streams, I decided to Join on record position to achieve the desired format.

Let me know if that works for you.

Cheers,

Angelos

Re: Shifting data in one column down by one cell

SureshBurra1982 — Tue, 19 Jan 2021 07:13:38 GMT

I have multiple columns in my case, just for example I just provided one random column for info, do we have any way that we can handle with in the Multi Row Formula?

Re: Shifting data in one column down by one cell

AngelosPachis — Tue, 19 Jan 2021 07:29:48 GMT

I guess so @SureshBurra1982 ,

My concerns with the formula tool is that probably you are going to need one for each column you want to offset, so it's not very flexible in the things it can achieve.

Give this another try, I have included another column in the input just to test what would happen in your case

and changed the union tool to keep all fields. Then the output looks ok: