How to duplicate and shift columns

[bruno_]

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.   

Before

Name	A	B	C
Name1	1	6	11
Name2	2	7	12
Name3	3	8	13
Name4	4	9	14
Name5	5	10	15

After

Name	A	B	C	newA	newB	newC
Name1	1	6	11	1	0	0
Name2	2	7	12	2	6	0
Name3	3	8	13	3	7	11
Name4	4	9	14	4	8	12
Name5	5	10	15	5	9	13

[AngelosPachis]

Hi @bruno_ ,

EDIT : missed the shift part

One way would be with a multi-field formula tool

Regards,

Angelos

[pedrodrfaria · Accepted solution]

Hi @bruno_ 

See the solution below:

Pedro.

[bruno_]

Ok, it works for the duplication, but what about the conditional shifting?

[pedrodrfaria · Accepted solution]

Hi @bruno_ 

I'm not sure you are responding to my post or the one above. But for the solution I provided, did I get the shifting logic incorrectly?

Pedro.

[bruno_]

Thanks guys @AngelosPachi and @pedrodrfaria.

Your worfklow worked, Pedro.

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?

[AngelosPachis · Accepted solution]

Hi @bruno_ ,

Sorry for missing that, here is a better solution than the one I provided earlier. This one actually does what you have asked, and will work for any number of columns.

Cheers,

Angelos

[bruno_]

Thanks!!