Select or Sum the position of the columns instead of by names

[Meiye]

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?

[FinnCharlton]

Hi @Meiye , here's a way to dynamically select and sum the first 6 columns:

[binu_acs]

@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

[FinnCharlton]

@Meiye do what @binu_acs suggested, it's much better

[Meiye]

Hi, @binu_acs 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. 

[binu_acs]

@Meiye is that something you are looking for?

[Meiye]

@binu_acs Thanks so much. It worked great! Learned a new trick today.