Data Cleansing

[SP3000]

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 !!

[Kenda]

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.

[atcodedog05]

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 : )

[SP3000]

Here is the file, can you please help? The criteria are value has to match and the date diff should be less than 5 business days.

[atcodedog05 · Accepted solution]

Hi @SP3000 

Give this a try

Workflow:

Hope this helps : )

[SP3000]

Thank you so much @atcodedog05  & @Kenda ! I really appreciate it!

[atcodedog05]

Happy to help : ) @SP3000 

Cheers and have a nice day!