I have an excel file ,using DT1 from this i am entering 2 column i am entering all data to the Queue.
and using “get transactions item” i can get them one by one.
But to the same excel file (DT1) i want to update the data, in other all other 20columns how to do it?
there are some 100 transactions i have to process them one by one and also to the same excel file enter the data ?
Hopefully you have in your excel a cell that can be used to find that item again from the queue, once it is processed, putting that also in the transaction item, in reference field or custom column, you can then use lookup range to find the address of the cell that is found, with that you will know the row number in excel that you need to update.