We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Data Manipulation

Ekmi9
8 - Asteroid
‎01-03-2023 04:10 AM

Hello Everyone,

 

Happy new year to everyone!

 

I need one help on below mention data manipulation 

Input:

 

Ekmi9_0-1672747796899.png

Output:

 

Ekmi9_1-1672747821429.png

 

 

Labels:
Reply
11 REPLIES 11
Ekmi9
8 - Asteroid
‎01-04-2023 12:56 AM

logic is simple in id = 5 have -10 value now we have only left 7 from id 1 so we use that 7 and the add 3 more from next "s" id which 4 so that we can have total +10 and we will subtract that value from ID 5 

Reply
0 Likes
Ekmi9
8 - Asteroid
‎01-04-2023 02:52 AM

any solution ??

 

 

Reply
0 Likes
Community Live
Labels
Top Solution Authors
View All