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

Alteryx Designer Desktop Discussions

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

Manage Layout Tool ~ if no Table Then Add Text String

Xervarian
6 - Meteoroid

Team, 

 

Challenge: a workflow is created for a report that disseminates to a reader base via email; part of the email body presents tables within the MANAGE LAYOUT tool in which occasionally there will be no data to present in the table and within the email body the space designated for the table will be blank; in this situation, I am looking to add a text string to that blank spot should there be no data table to add. 

 

Summary: IF data table is present, present table in email body, IF NO data table is present, present text string "No Errors Today" in same email body location

 

How is this done? 

2 REPLIES 2
Armon24
Alteryx
Alteryx

Hi @Xervarian 

 

I may have an idea that might work for this. Before you render the table, bring on a Formula Tool that has a condition that follows this logic: IF IsNull([Table]) THEN "No Errors Today" ELSE [Table] ENDIF. This way you can account for the instance it is blank, and also still bring in the correct table if data persists. 

Felipe_Ribeir0
16 - Nebula

Hi @Xervarian 

 

One way of doing this

 

Result when there is no data on the table

Felipe_Ribeir0_0-1670611846325.png

 

Result when there is data on the table

Felipe_Ribeir0_1-1670611900222.png

 

 

Labels