I’ m having some issues with the excercise. I’ve followed the problem back to the GetWorkItems sequence. Which Extracts structured data (all of the work items unfiltered and should put the result into a datatable variable which I have created, so why doesn’t it???!!!)
properties for the Extract data activity with the output going to dtWorkItems
I can see the extract going through the webpages until the last one so it should be picking up the data and the output datatable is there also (so what is going wrong?)
@Jersey_Practical_Sho. Thanks very much for the info putting that default value in enabled me to write range to excel (first column is blank don’t know why but at least there is now data there).
Do you know why this New Datatable default has to be added. Is it becasue it is an object rather than just a normal variable (most variables don’t need a default when they are created so why does this?) .
When I originally went through this exercise, I had exactly the same issue as yourself. So I Started over from the very beginning of the Scraping process and the system added New System.Data.Datatable in when I completed the extract data table part.
I am literally at the point just after you and now Im stuck on the Assign part or moreover where it goes. Ill add you as a friend on here and see how we get on?
Thanks @irahmat for the info I think I had to do some regex (and I don’t know anything about regex I found an example in the forum somewhere so that the result would only allow letters and numbers to get rid of non printable characters like newline that wasn’t being removed by the trim function)
The split part finds the text between Client ID: and Client Name: (it takes the array index (1) )
The regex bit only allows characters and numbers so hidden characters are removed.
system.Text.RegularExpressions.Regex.Replace((Trim(AllWIDetails.Split({“Client ID:”, “Client Name:”}, StringSplitOptions.None)(1))), “[^a-z A-Z 0-9]”, “”)
I got the basis of this from the forums (I couldn’t find this material in any UiPath learning materials, which I think it should be if in the walkthrough it basically says
I don’t think that this was covered sufficiently in the learning materials (In my opinion).
As for the assign you need to create a out argument and then assign the datatable to it (it’s in my xaml from the first post, if that’s the assign you’re talking about)
