Problem: I am trying to get single rows from a collection whose fields are defined at the runtime, but the single row feature is not enabled until I define the collection fields.
Exercise: Currency conversion using workqueue.
Assumption: Excel file have huge no of fields and I only need to perform actions on some of those fields.
Logic: I am trying to add the excel data into queue after going through an empty row check and empty cell value check, in case there is am empty cell is present I will delete that row from the "get worksheet as collection"-collection and execute the rest queue items and save it to worksheet. I am thinking to get the collection data as single row and check if any field is empty then a decision stage will either write the data to collection or delete it..
Exercise: Currency conversion using workqueue.
Assumption: Excel file have huge no of fields and I only need to perform actions on some of those fields.
Logic: I am trying to add the excel data into queue after going through an empty row check and empty cell value check, in case there is am empty cell is present I will delete that row from the "get worksheet as collection"-collection and execute the rest queue items and save it to worksheet. I am thinking to get the collection data as single row and check if any field is empty then a decision stage will either write the data to collection or delete it..
Last edited: