Iterate Names through column Title

Help
, , , ,
1

I would like it to be For each name in the column title, take the name and search into the bbc news search bar where it then screen scrapes the data in each article.
Populate_Newsletter.zip (21.3 KB)
The difficulty I am having is with the code snippet below with foreach item in the data frame and then calling item.toString

image
image1920×1040 69.6 KB

2

Do you want to iterate through each column, or each row in the datatable? I can’t open your workflow as i am still on 2018.4.3, but based on the picture you are currently iterating through each row of the datatable.

What do you mean by each name in the column title? Assuming that the CSV in your zip file is the datatable you are working with, there are no column headers. Therefore column 1 is going to be named Column 1, column 2 is named Column 2, etc

3

@Stabbathehut
Let assume you want to Iterate over each datarow and using the value of a particular column for doing the search.
Item(YourColumnNameOrIndex).ToString should do the job

4

exactly what problem you are facing?

5

That’s great thanks!

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.