Hi, I am trying to get the below output, please assist.
Input | Ouput | |||
No | Sum A | No | Sum A | |
1 | 100 | 1 | 100 | |
1 | 120 | 1 | 120 | |
1 | 1 | 100 | ||
1 | 1 | 120 |
Thank you in advance !!
Solved! Go to Solution.
Hi @SP3000
I'm not exactly sure what your whole dataset looks like and therefore if this will work for you, but with this sample data, here is one way to accomplish this:
1. Use a filter to separate the records that are null in the Sum A field.
2. Use a join tool to join records by record position.
3. Use a union tool to keep the populated records from the filter tool and the joined records from the join tool.
Hi @SP3000
Interesting use case, just curious to understand why do you want logic like this. If there were more rows and if the logic was like below.
Here is a solution for it. If the logic is more variant do let us know. Would love to work on a solution for this interesting use case.
Hope this helps : )
Thank you so much @atcodedog05 & @Kenda ! I really appreciate it!
Happy to help : ) @SP3000
Cheers and have a nice day!