So I have a Excel file as the input with 4 columns.
If I wanted to have the first cell of the first row and then continue looping trough I would do it like this:
The problem I have is that I dont know how to this same thing with the whole row. I want to add the get the values of the cells under each column.
I have tried this:
But the counter does not work with this one so I remove the whole Data Row so I dont repeat in for the next transaction. The problem is that this part gets messed up:
I only get half of the transactions processed.
How can I do this better or make the counter work just like with a single column and cell.