topic Re: Forluma based on column order in Alteryx Designer Desktop Discussions

Forluma based on column order

petros21 — Mon, 05 Dec 2022 13:28:20 GMT

Hi,

I want to do some maths in a new column based on the order of the columns.

Based on my query the headers could have different name.

For example I want to calculate --> 3. column + 4. column

Thanks in advance

/Petros

Par_O_SE — Mon, 05 Dec 2022 13:38:47 GMT

@petros21 Can you expand a little on this? Do you want to add values from two or more columns based on the names of the columns?

petros21 — Mon, 05 Dec 2022 14:31:41 GMT

The headers of the last 3 Columns are changing every month based on my select (--> last 3 months).

I want to calc the average of the last 3 months.

Following worked last month, but of course not this.

Reaseon: the last three columns are from this month

Thanks in advance

gautiergodard — Mon, 05 Dec 2022 14:43:28 GMT

If I understand your problem correctly, here is one way you could do this:

Hope this helps!

binu_acs — Mon, 05 Dec 2022 16:41:39 GMT

@petros21 One way of doing this with the Dynamic Select tool

petros21 — Mon, 05 Dec 2022 16:41:45 GMT

Thx guys. It was easy - at the end :) ....

I used the dynamic renaming tool