This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
Hey guys, I'm struggling with this operation in Alteryx and I would be very grateful if someone could help me. I tried to use formula, multi-field formula, multi-row formula but couldn't make it so far.
It is just a meaningless example below, but I want to duplicate columns from A to C, giving them a new name (in the example newA, newB and newC) and shifting them down like this:
newA = A shifted down by 0 cell
newB = B shifted down by 1 cell
newC = C shifted down by 2 cells
and so on...
Also, where might be Blanks or Nulls in consequence of the shifting, I want to put a 0.
I just have another issue: what if the number of columns are bigger? I have to do this operation in dozens of columns and with this program I would have to use the Multi-row formula tool dozens of times. Is there any other way?