2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

How to Shift Data down by one row

wumbo1
6 - Meteoroid

I'm looking to shift data in the cells of a column down by one row like this: 

 

Original: Capture.PNG

What I'm trying to do: 

Capture99.PNG

Is this possible in designer? 

5 REPLIES 5
PhilipMannering
15 - Aurora
15 - Aurora

Perhaps this is one (of many) ways to do it....

PhilipMannering_0-1656022517475.png

 

binuacs
15 - Aurora

@wumbo1 Another way of doing this

binuacs_0-1656022968371.png

 

PhilipMannering
15 - Aurora
15 - Aurora

@binuacs Oh, I like that better.

Hi @wumbo1 

 

Is there a logic behind this operation?

 

I did it by basically splitting the columns. I added an empty text input and added it to your Value column to create the empty cell. I then joined the 2 columns based on position to shift the data down. Cheers!

christine_assaad_0-1656023229263.png

 

wumbo1
6 - Meteoroid

@PhillipMannering

@binuacs

Thank you both of your for your responses. Both solutions work great. I also found that by creating a new field in the multi row formula, setting the "Values for Rows that don't Exist" parameter to 0 or empty, and putting [Row-1:Total NAV] has the same effect. 

Labels