We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

Data Shifted to next column

enkenmendoza
7 - Meteor

Hi I am currently facing data shifting issue. There is one column that I just want to move it according to its right position. I just want to fix it

 

From this:

 

F1DocNoDocdatePostdateCodeNameTypeAmountSGAsgText
100814315910/19/202010/20/2020500010Utilization ExpenseK1600 166448501-PF1DR-9307-10-19-20 
 100814316110/19/202010/20/2020500010Utilization ExpenseK1600 166531346-PF1DR-9307-10-19-20

 

To this:

 

F1DocNoDocdatePostdateCodeNameTypeAmountSGAsgText
 100814315910/19/202010/20/2020500010Utilization ExpenseK1600 166448501-PF1DR-9307-10-19-20
 100814316110/19/202010/20/2020500010Utilization ExpenseK1600 166531346-PF1DR-9307-10-19-20

 

Could you help me with this one pls?

2 REPLIES 2
AngelosPachis
16 - Nebula

Hi @enkenmendoza ,

 

The slightly painful way to do that is through a union tool. You can split out groups of records that have been moved by one column to the right/left and then bring them together with a union tool.

 

The union tool will allow you to manually configure which fields are stacked together.

 

AngelosPachis_0-1615974293208.png

 

Hope that helps,

 

Angelos

danilang
18 - Pollux
18 - Pollux

Hi @enkenmendoza 

 

How do you know which rows need to be adjusted? Is it always the ones that have a value in F1?

 

Dan

Labels