Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Help

Mina2021
8 - Asteroid

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.

5 REPLIES 5
AngelosPachis
16 - Nebula

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
8 - Asteroid

Hi 

 

 

Mina2021_0-1616480983448.png

Backward should be-

Mina2021_1-1616481015043.png

 

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

2.Forward ( no null action) -

Mina2021_2-1616481091286.png

Backward should be as it is -

Mina2021_3-1616481117539.png

3. Forward -

Mina2021_4-1616481237363.png

Backward should be-

Mina2021_5-1616481273429.png

 

 

If you could help me, would be great!

 

P.S - Sorry I have attached wrong file.

 

 

 

 

 

 

 

Mina2021
8 - Asteroid

  Hi 

 

Qiu
20 - Arcturus
20 - Arcturus

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

20210323-Mina2021.PNG

Mina2021
8 - Asteroid

Hi Qiu,

 

It's working perfectly.

 

Thank you for your support!

 

 

Labels