I’m having a bit of a problem understanding the fundementals of the DataTable in UiPath. I seem to be able to understand and visualize the data I’m handling when I use ‘Build Data Table’ and manually insert values for the rows/columns but I’m having trouble reading a CSV file column, passing the data into a Data Table Column, creating another column in the UiPath Data Table and filling it up with other data already obtained by other activities in UiPath and passing it to a CSV file.
Basically the workflow is like this:
=> one column in CSV with ‘CompanyName’ has items
=> insert into UiPath datatable ‘CompanyNames’, use activites to get web sourced URLs for the items aka CompanyURL
=>pass the UiPath Data Table, now with two columns (CompanyName + CompanyURL) back into another CSV file.
My problem is that the URL info isn’t being passed to the CSV file and I have no idea how I can “peek” into the UiPath DataTable that I’m creating and seeing if it’s actually storing the information properly so that I can narrow down the problem.
Here is the workprocess:
Thank you! I was able to see that the CompanyURL seems to work but it’s not being passed to the CSV file. I think this is odd because when I made the CompanyURL column I aligned it under Data Table “CompanyNames” and I’m using the Write to CSV activity to pass the Data Table “CompanyNames” but the CompanyURl isn’t being passed
Anyone have any ideas?
The screens of the workflow is in the top original post that I made, same for the datatable values, they are in the second answer (i think) but here is the file just to be safe: Main.xaml (26.2 KB) project.json (1.5 KB)
Thank you so much! I was finally able to pass the links to the CSV File!
One question, if you have time - I would like to have the URL specifically pasted into the B Column, with the Company Name in the A column. Would I do this with another Add Data Column and another “Assign” activity? When I try replacing “Column1” with “Column2” and add another “Add Data Column” I just get the same result as before:
For preparing am empty datatable with the datacolumn structure we would like to have also have a look at the build datatable activity, often use for this purpose (we model the structure, and populate it later within the loop)