community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

Getting Error in the Formula Output tool.

Highlighted
Meteor

Hi all,

I am getting this eror in formula tool where I want an output of a table based on the count. if the count is 0 then the Table would be table 2 otherwise it should be Table1

thanks.

Capture.pngCapture1.PNGCapture2.PNG

Asteroid

Hi - what's coming through that output is the HTML behind the table view in browse. I don't think you can just assign a new field to be that table. What you could do, though, is a transpose and then filter on the "Name" field coming out of the transpose ([name] = either Table1 or Table2 depending on count).

 

Workflow attached might help you get going

Labels