Excel Manipulations (Row move, copy, delete)
Hi, I would like to use Tosca to do some excel manipulations, in essence building a kind of archiving routine.
See attached excel file as example.
We have a list of rows in 1 excel tab "MAIN". This list is populated by manual/automated processes outside of TOSCA.
We would like to build a TOSCA routine which is
- reading this "MAIN" tab
- identifying items/rows which are older then 30 days (based on the values in Column D)
- then copies those rows to tab "ARCHIVE" at the first available next row
- then deletes the row in the "MAIN" tab
Is this something which can be done? and if so, how can we do this?
- copying excel rows
- deleting excel rows
[Originally asked and solved on Support Hub]
Best answer by Community AdministratorView original