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?
Solved! Go to Solution.
Hi @Jake5
Change the XML formula by this one: '<Field name="' + [Name] + '"' + ' selected="True" Alignment="Left" Width="" />'
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/
User | Count |
---|---|
60 | |
24 | |
24 | |
21 | |
21 |