I'm currently working on compiling a report in Alteryx and I need assistance with updating a specific value within my dataset. Here's how my data is structured: Name24-Jan24-Feb24-MarTotal1 req received1241301173712 req closed8788732483 req open1351722095164 req cancelled133117 This is how i want my output. Please note that the number of columns will be dynamic so if i have 7 columns then the 6th column's value will need to be used Name24-Jan24-Feb24-MarTotal1 req received1241301173712 req closed8788732483 req open1351722092094 req cancelled133117 Thank you

Updating Specific Value in Alteryx- Need Help with Dynamic Value Assignment

I'm currently working on compiling a report in Alteryx and I need assistance with updating a specific value within my dataset. Here's how my data is structured:

Name	24-Jan	24-Feb	24-Mar	Total
1 req received	124	130	117	371
2 req closed	87	88	73	248
3 req open	135	172	209	516
4 req cancelled	13	3	1	17

This is how i want my output. Please note that the number of columns will be dynamic so if i have 7 columns then the 6th column's value will need to be used

Name	24-Jan	24-Feb	24-Mar	Total
1 req received	124	130	117	371
2 req closed	87	88	73	248
3 req open	135	172	209	209
4 req cancelled	13	3	1	17

Thank you

Dynamic Processing

Join

Accepted answers

danilang

Hi @Vineet003

Here's one way to do it

First transpose the data and spilt into "3 req open" (bottom) and other (top). Sum the top grouping on Name and take the last value from the bottom. Rename the Value column to Total and union with the top rows. Join this with your original data on Name and the sort to get the original order.