I just want to easily create a row total for 24 fields without typing out the names of each field. For instance, for all the fields contain the string "DIAG," I just want to create a formula that says sum this row for all fields with "DIAG" in their name. Is there a simple way to do this?
Side Question: Let's say I have 24 fields and I have a reference table that would test the value of each entry in those fields. For instance, let's say each field is a code that goes from A to Z. I have a reference table that identifies certain letters as 1 and the rest as 0. Is there an easy way to append this reference table and total the rows?
Imagine Product A has A B C Z Z Y. the reference table converts those to 0 0 1 1 1 0 so a new total would be 3 for that row. My goal is to get to the 3 number. What's the easiest way to do all these steps in alteryx? I can't find an easy array tool.
