Shifting data in one column down by one cell

Question

Hi,

I have one column where I need to shift only that column to one cell down.

Input

Output

AngelosPachis · Answer

I guess so @SureshBurra1982 ,

My concerns with the formula tool is that probably you are going to need one for each column you want to offset, so it's not very flexible in the things it can achieve.

Give this another try, I have included another column in the input just to test what would happen in your case

and changed the union tool to keep all fields. Then the output looks ok:

example_v2.yxmd

SureshBurra1982 · Answer

I have multiple columns in my case, just for example I just provided one random column for info, do we have any way that we can handle with in the Multi Row Formula?

AngelosPachis · Answer

Hi @SureshBurra1982 ,

You can do than by offsetting that original C2 column by one cell, essentially pushing everything a place downwards.

I used the generate rows tool to generate that single null cell and then unioned it at the top of the Old C2 column. Then bringing back the two streams, I decided to Join on record position to achieve the desired format.

Let me know if that works for you.

Cheers,

Angelos

example.yxmd