Discussions

I have a set of survey responses with 10 questions where the customer could select one of six responses. I need to calculate the percentage of responses that equal 'Agree' or 'Strongly Agree'.   Here (and attached) is an example of what my data looks like:     I was able to count the sum of each answer and then make a formula that added together the percentage of Agree and Strongly Agree for the entire data set, but the data will need to also be matched to Client and Sector so I need to be able to factor in the RecordID and I'm not nearly advanced enough to come up with how to do that.   Hoping someone can help a beginner here who is struggling!   ... View more

😅   ... View more

I am trying to use Regex to recognize the strings with 3 characters and replace them with nothing. Example,"IDC". What would be the syntax for this? ... View more

I have a business case where I need to insert a special character such as a Check or X for the for a given value if the conditions are met. this is obviously not the correct syntax for the expression but this is the concept I am trying solve.   If Submission date ="1" then "Special Character "X" + Submission Date" else Submission date endif   For reference I found this article on the message board which works great for replacing.   https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Issue-with-PNG-PDF-output-for-special-character/td-p/141935     This is a example of how I would like it to look in the end.     The attached workflow has some dummy data to help kick off the process.   Thank you in advanced.   ... View more

  Hi,   I have a workflow where my input looks like this Name 2021-05-11 Age9_44 2021-05-12 Age9_45 2021-05-13 Age Sam 12000 1 13000 2     Huge 44000 60     34000 1   I want my data as below for my further expressions :   Name 2021-05-11 Age9_44 2021-05-12 Age9_45 2021-05-13 Age9_46 Sam 12000 1 13000 2     Huge 44000 60     34000 1   The Age column keep adding on so tomorrow it will, be Age.i want alteryx to check the previous Age column header and add a digit to it. Is this possible?  ... View more