I’m extracting data using from a website using the data extraction tool. I have used a “Repeat number of times” activity as there are multiple pages (and “next link” functionality doesn’t work in this case).
My iteration successfully goes through each page, but it overwrites the data in the excel. So I thought I’d duplicate each iteration result in a new sheet that will be named whatever the CurrentItem is, but I can’t figure out how to get past the error below.
Hope currentItem variable is of type Integer here. If yes then write currentItem.ToString in Duplicate sheet activity.
Thanks, but I have already tried that. I get the same error:
Can you try to modify expression to
CurrentItem.ToString at NewVariable in variable panel, too?
Thank you, Yoichi! That solved my problem. Looks like I forgot to delete that variable. Much appreciated!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.