Hi,
I have extracted table data into a datatable which has 2 columns “Folder Name” and “Folder Name Url” .
My goal is to navigate to the url present at “Folder Name Url” for each row in the datatable to extract further information.
Problem: I am unable to print CurrentRow(“Folder Name Url”).Tostring and also unable to navigate to url.
What am i missing here?
I would like to do it without writing datatable info to a file and then use it.
Thanks you.
Hello @safiya1 Print all column names to check
Add a write line before the loop and pass String.Join(", ", DestinationDataTable.Columns.Cast(Of DataColumn).Select(Function(c) c.ColumnName))also ensure in your write line activity you’re passing To String pass varibale of OutPut Datatable as Text activity also add a write line and pass DestinationDataTable.rowcount to check if any row exists like any datat is there after extraction or not.
then pass CurrentRow(“Folder Name Url”).ToString.Trim or by index like CurrentRow(1).ToString in write line inside for each activity see if this works or not if works then pass it into go to url activity.
Cheers
hi, @safiya1
you can do this: Inside the For Each Row in DataTable loop use CurrentRow("Folder Name Url").ToString for printing and as the URL in the Go to URL activity.
as per logs looks like the currentrow(“folder name url”).tostring is considered as text..may be you gave in doubel quotes..to confirm click on settings icon beside it and check open advanced editor and you can see how it looks..ideally it should not have double quotes around it
if formula then it would have been in blue color
cheers
@Anil_G , Thank you, I did not realize it was taking it in double quotes. silly me. Thanks for the help.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
