Alteryx Designer Discussions

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

How to move one column to the right

8 - Asteroid

Hi I have a dataset but it is is not align properly because of missing data, now I have to move those columns to the right



Idnameplacequantitypricefruitrow number
456214Raj10.00100.00apple 2
456214Timnew york10.0010.00banana3
456214  25.00125.23banana4
145267EXLuffy5.0060.00apple 6
145267EX  10.0080.00banana7
54123  5.0010.00apple9



1. If you will see row number 2 and 6 the place is missing so to align it correctly I have to move all the columns one to the right

2. If you will look at row number 4 and 9 the alignment is correct So we don't have to do anything



Idnameplacequantitypricefruitrow number
456214Raj 10.00100.00apple2
456214Timnew york10.0010.00banana3
456214  25.00125.23banana4
145267EXLuffy 5.0060.00apple6
145267EX  10.0080.00banana7
54123  5.0010.00apple9


What will be the best method to push the row to the right


Note: We can only use alteryx tools.


Attaching the csv file for the above table

15 - Aurora

Hi @Sshasnk ,


I have managed to do whta you are looking for with a filter tool and then a union tool, in which I have manually configured the columns.




That's one way to do it and will solve your problem until you output the data in the right format.


Hope that helps




16 - Nebula

Hi @AngelosPachis,

This is smart. Easy to implement and easy to explain to others. I will remember this solution for the future. 


7 - Meteor

@AngelosPachis that's beautifully simple.


I had a similar issue myself, and went via a more convoluted route :

  • Create boolean field to identify if row needs aligning, then filter true and false to split into two workstreams.  Something along the lines of ISNULL([place]) OR ToNumber([place])=0 
  • In the true workstream, use Field Info tool followed by RecordID.
  • Add Formula Tool to adjust RecordID (something along the lines of IF [recordID]<2 then [recordID] else [recordID]-1 endif
  • Dynamic rename twice, once to convert field names to rowID, then rowID back to field names the latter using the new, adjusted recordID above
  • Union with the false workstream

It worked, but yours is much more elegant 🙂


...and I knew you could do that, clearly didn't occur to me at the time!

15 - Aurora

Hi @Emil_Kos and @leon2020 ,


I'm really glad that you found this solution helpful and thank you for taking the time to write a comment and share it.


Unfortunately, it's a manual process to configure the union tool, but it will work if it's a one-off.


Enjoy the rest of your day!

17 - Castor

Can you also give feedback to your another thread?

I believe the repliers would appreciate your feedback and even better you would mark it as acceptable if you find the anwser useful.