Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Shift multi columns with Multifield function

yfang0
5 - Atom

Hi, I am new to Alteryx, and have a dataset misaligned to the right by 2 columns, for example like this

yfang0_0-1656362889795.png

 

I plan to use Multifield function to shift the columns back like following

yfang0_1-1656362922690.png

 

Given I have 100+ columns to shift left twice back to column C, I can't use simple = formula 100+ times.

This Multifield formula doesn't work [_CurrentField:Column+2].

Can anyone share any insight? Thanks.

3 REPLIES 3
IraWatt
17 - Castor
17 - Castor

Hey @yfang0,

When there's lots of columns transposing is usually a good first idea:

IraWatt_0-1656363540045.png

Any questions or issues please ask :)
HTH!
Ira

 

 

yfang0
5 - Atom

It works! Thanks @IraWatt 

IraWatt
17 - Castor
17 - Castor

No worries @yfang0! If your happy with that solution make sure to leave a green tick 😄

Labels
Top Solution Authors