Help

[Mina2021]

Hello,

I have data set with some null values where there is no action for each code and objective is to shift the null values in the front. where there is null action, that needs to be in the action 1. Need to make it dynamic.

Kindly help me to solve!

Thanks in advance.

[AngelosPachis]

Hi @Mina2021 ,

So once you've shifted all the null values under action_1, what do you want to replace those values under actions 4 and 5?

Can you provide a sample of the output you're after?

Thanks,

Angelos

[Mina2021]

Hi AngelosPachis,

I have attached the format in the Backward tab of the file.

example:

 1. Forward (only one null action)-

Backward should be-

If there is no null action then, will remain the same as Forward view:

2.Forward ( no null action) -

Backward should be as it is -

3. Forward -

Backward should be-

If you could help me, would be great!

P.S - Sorry I have attached wrong file.

[Mina2021]

  Hi  AngelosPachis,

I have attached wrong file in the previous reply.

Now I have modified the reply.

Kindly check!

[Qiu · Accepted solution]

@Mina2021 
I hope it will work in your really business flow given the naming convention for columns will follow 'Action' and 'Diff'.

[Mina2021 · Accepted solution]

Hi Qiu,

It's working perfectly.

Thank you for your support!