I need to find the column index of a particular column from an excel file?
read csv file
dump csv data to Notebook’s scratchpad
find index of the column (A e.g.) → This can be varying on each iteration
Column A can vary on its position in each iteration.
Iteration1: it may be the 1st column
iteration2: it may be the 12th column
iteration3: it may be the 100th column
and so on.
There are no activities offering direct column based processing at this time, since we’ve considered this as a less common case. Could you please give us more details on what you are trying to achieve? cc: @AndrewHall
Copy paste range with transpose in a temporary sheet & for-each row, as already suggested: