Insert rows when column value changes

Ask a question
1

I have a table sorted by a column value “weight.”

Every time the value in the column changes, I want to insert a new record before the record containing the new value along with some text. Possible?

|Column 1 | Column 2 | Column 3 | Column 4|
|id | weight | Product Info | —|
| 1| A | Product Text A | |
| 2| A | Product Text A| |
| 3| B | Product Text B| |
| | | | |
| | | | |
| | | | |

|Column 1 | Column 2 | Column 3 | Column 4|
|id | weight | Product Info | —|
| 1| A | Product Text A| |
| 2| A | Product Text A| |
| 3| A | Newly Inserted Text For Record Change | |
| 4| B | Product Text B| |

2

Hi, welcome to the community!

If you’re looking to alter a specific step based on changes to the data between runs, you’ll need to save the prior and current data with some database (Excel, Parabola Tables) and use an if-else to compare differences and make action based off of that.

To get an answer more specific to your use case, you can email help@parabola.io with your flow link and we can help troubleshoot.