Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Shifting data in one column down by one cell

SureshBurra1982
7 - Meteor

Hi, 

 

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

Input

 

SureshBurra1982_1-1611034615044.png

 



Output

SureshBurra1982_0-1611034565844.png

 

6 REPLIES 6
SureshBurra1982
7 - Meteor

Sorry Input is below

 

SureshBurra1982_0-1611034826962.png

 

Tyro_abc
11 - Bolide

This is my try, please check..

Spoiler
arundhuti726_1-1611039288338.png

 

SureshBurra1982
7 - Meteor

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.

AngelosPachis
16 - Nebula

Hi @SureshBurra1982 ,

 

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

 

AngelosPachis_0-1611040060203.png

 

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

 

SureshBurra1982
7 - Meteor

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?

AngelosPachis
16 - Nebula

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

 

AngelosPachis_0-1611041194682.png

 

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

 

AngelosPachis_1-1611041236136.png

 

 

Labels