Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Retun a specific string if all row are null

Rob48
8 - Asteroid

Is there a way to get a specific string to return if all rows in a column are null?

 

My data comes daily with 3 columns, "Name," "Action," and "Items" of around 500 rows and i've set my workflow to add columns with the date as in the below table.  On some days there is no data so the file comes with the "Action" and "Items" columns with the dash and 0 in all 500 rows but the "Name" will return all nulls.  On days where there is no new data and all Names are null I want to return "no data today" in the first row of the "Name" column.  Then I filter out all the rest of the nulls and my summary will show "no data today" for that date.    I've been working on this all morning but can't pull it together and I haven't found anything here.  Seems like there'd be a simple tool or formula that would get me what I need in one step.  Thanks for any help you can provide.

 

 

Date of EntryNameActionItems
11-Dec-24(null)-0
11-Dec-24(null)-0
11-Dec-24(null)-0
11-Dec-24(null)-0
11-Dec-24(null)-0
11-Dec-24(null)-0
11-Dec-24(null)-0
2 REPLIES 2
binuacs
21 - Polaris

@Rob48 you can use the count record tool to take the total count and count the Null() values and if both are matching means all the fieids are null then you can update the first cell value of name field as "no data found", sample attached

image.png

Colman_Hendershot
6 - Meteoroid

deleting earlier response

Labels
Top Solution Authors