Date Age Column Issue

clarrock

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? 

apathetichell

The short is SURE! Can you explain though how the data is coming in/being updated. Is it a new file where the column i always called "age"?

Ideally it's probably easiest to transpose it and then perhaps use a multi-row or something to look for the row two rows above it (assuming that that is where the previous age is).

then you do something like

left([row-2:name],length(row-2:name]-1)+tostring(tonumber(right([row-2:name]),1))+1)

or something like that.