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

How to fill in nulls w/data from row below-Same Data but different values in two fields

blitz45
8 - Asteroid

Hi There!

 

Below is a screenshot of my workflow. The second screen shot is what I am trying to achieve but have failed to do so. Please help? 

How do I get the values from "NAME NO" filled in to the nulls and same with "NAME YES". 

I am trying to consolidate the rows because all of the data are the same and I am trying to have just one row by filling in the nulls with the value below. 

 

 

blitz45_1-1600987573311.png  

blitz45_2-1600987737424.png

 

Thank You,

 

 

3 REPLIES 3
bpatel
Alteryx
Alteryx

hi @blitz45 ,

 

You can use the multi-row formula to fill in values like this 

bpatel_0-1600989306096.png

 

hope this helps!

 

vizAlter
12 - Quasar

Hi @blitz45 — Try this solution... solved through "Tile" and Cross Tab" tool:

 

vizAlter_0-1601006798503.png

 

 

Please mark it "Solved" or "Solved" with a Like if it resolved your query. This will help other users find the same answer/resolution.  Thank you.

grazitti_sapna
17 - Castor

Hi @blitz45 , try this if it works for you.

grazitti_sapna_0-1601011503188.png

 

Thanks.

 

Sapna Gupta
Labels