community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

How can I shift row left?

Highlighted
Atom

Hi all,

As you can see in the screenshot, the row has misalignment from [host_name]. How can I shift the row left from [host_name] column?

 

clipboard_image_0.png

 

Thanks for the help!

Alteryx Certified Partner

Hi @Lemirra 

 

Solution is attached

 

Snag_81be9d68.png

 

 

By transposing the data, moving rows required to move via the Multi-Row Formula Tool, and then crosstabbing the data back into its original form we are able to move the columns in a dynamic way. 

 

The tricky part is in making sure that all columns downstream of the column requiring moving are flagged via a multi-row formula. Once the data is grouped into "Keep these values" (Flag = 0) and "Update these values" (Flag = -1) it becomes easier to approach the problem. 

 

Hope this helps! 

Atom

Thank you so much! This helped a lot!

Labels