Hi everyone, I can't begin to think of a solution, so I need some help. Thanks in advance.
In this case, I want only the first 6 columns, and in a later step add a column of the sum of the six. The issue is that the column names are going to change each week, as they are the Sundays of a week. The select tool is going to count the columns as "Missing" and mess up the following steps. Is there a way to work around this?
@Meiye One way of doing this is with the dynamic select tool. This tool is set to always select the first 6 columns then calculate the sum
Hi, @binuacs Thanks for the tip. However, since there are multiple records, it's giving me this at the transpose step:
Then the sum just sums the entire value column.
@binuacs Thanks so much. It worked great! Learned a new trick today.