We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Table error when records are missing

Jake5
8 - Asteroid

I have a workflow that in some instances will have records with values and other instances with no records.  Attached is a mocked up example where my initial input has two fields - Category A & Category B - but no underlying data.  And for additional context, the subsequent tools are used for instances where these fields have values, the data will list first and any null values will sort last.   Thereafter, the New Field column is no longer needed and should not be written to the table.  However, when unselecting New Field within the table, the table produces an error.  For this scenario where no records are present, is there a way to have Alteryx bypass this table and only write when records are available?   

10 REPLIES 10
Felipe_Ribeir0
16 - Nebula

Hi @Jake5 

 

Change the XML formula by this one: '<Field name="' + [Name] + '"' + ' selected="True" Alignment="Left" Width="" />'

 

Screenshot 2023-08-23 134429.png

 

1-If you want to know more about what is happening with this XML/Macro, take a look:

https://www.thedataschool.com.au/ryan-edwards/update-raw-xml-in-alteryx-macros/

 

Labels
Top Solution Authors