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