Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Vineet003
7 - Meteor

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-MarTotal
1 req received124130117371
2 req closed878873248
3 req open135172209516
4 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-MarTotal
1 req received124130117371
2 req closed878873248
3 req open135172209209
4 req cancelled133117

 

Thank you

 

 

3 REPLIES 3
aatalai
14 - Magnetar

@Vineet003 take a look at the flow attached this could help with tranpose and summarise and join to be dynmaic

danilang
19 - Altair
19 - Altair

Hi @Vineet003 

 

Here's one way to do it

w.png

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.

 

r.png

 

Dan 

Vineet003
7 - Meteor

Thank you @danilang ! :D

Labels
Top Solution Authors