We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Move a column one cell up

Nuno_Meneses
7 - Meteor

I'm new to Alteryx and I hope you can help me shifting a hole column one cell up. Thank you in advance.

 

2023-08-08 10_49_34-Alteryx Designer x64 - New Workflow1_.png2023-08-08 10_50_06-Alteryx Designer x64 - New Workflow1_.png

1 REPLY 1
ShankerV
17 - Castor

Hi @Nuno_Meneses 

 

Using the below 2 tool, you can achieve the result

 

1. Dynamic Rename tool

Rename Mode: Formula

Expression: "Serial"

 

 

2. Multi-row formula

Select Update Existing Field

Expression: [Row+1:Serial] 

 

Many thanks

Shanker V 

Labels
Top Solution Authors