Alteryx Designer Desktop Discussions

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

How to retain fields with null values alongside fields without null values

Jake5
8 - Asteroid

I have a workflow where the desire is to filter out null values for fields with data but also retain fields where all values are null.  Using the attached workflow, fields 1 - 3 have a combination of actual values + null values while field 4 only has null values.  I've succeeded in stripping out the null values for fields 1-3 but in the process, I lose field 4 at the very end.  How do I reinstate field 4 in the final output?  It might be worth noting these results can change month over month.  So next month, I might have all null values in multiple fields and would need these to be reinstated in the final output.  Any suggestions?  

2 REPLIES 2
Felipe_Ribeir0
16 - Nebula

Hi @Jake5 

 

Check this adapted version of your workflow:

 

forceheaders.png

Jake5
8 - Asteroid

Thank you, Felipe!  That solved my issue.  

Labels