Assistance Required for Sorting and Inserting Rows in Alteryx

MilicaCovin

I need help with sorting values from column:Cumulative Total and inserting them into column:Cumulative Total1  while preserving the order of column:Cumulative Total1. Here’s the process:

1. Identify Insertion Point: For each value in column:Cumulative Total, find the first larger value in column:Cumulative Total1 and insert the value above it.

2. Continue Insertion: Move to the next value in column:Cumulative Total1, find its insertion point for secund value in column:Cumulative Total, and insert it accordingly.

3. Preserve Order: Ensure the order of column:Cumulative Total1 remains unchanged.

Screenshot 2024-08-06 104736.png

ChrisTX

Can you post sample data in an Excel file, instead of a picture?

Is your data guaranteed to have a value in either Cumulative Total OR Cumulative Total1, but not both?   (one of the fields will always be Null?)

Chris