Trouble passing data through DataTables

Help Activities
, , ,
1

Hi everyone,
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:

image
image1066×1110 98.8 KB

I’m creating a new topic since the old one was focused on other activites related to this project. Again, so thankful for your help!

Best regards

2

Hi @Happy_Code_Happy_Life,

If you want to visualize data you can use the output data table which will convert the data table into a string and try to debug it.

Also, If you want to see the data table u can directly view it in Locals panel while debugging.

Thanks,
Firoz

1 Like
3

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 :thinking:
Anyone have any ideas?

image
image1367×846 47.3 KB

4

Hi @Happy_Code_Happy_Life,

Can you please share screenshots of the workflow and data table value after filling it in?
And if possible directly share the code which you have written.

Regards,
Firoz

5

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)

6

have a look here:

Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

Escpeically working within the immediate panel we can do additiona inspections and also prototype statements

1 Like
7

Give a proper name as value, when using a variable:

grafik
grafik786×511 48.4 KB

1 Like
8

Once you had extracted / calculated the url you would set the value to the column CompanyUrl e.g during the loop with an assgin activity:

CurrentRow(“YourColName”) = strURLValue

As we dont see such a step within yiur modelled flow, it explains why it is missing

1 Like
9

Thank you so much! I was finally able to pass the links to the CSV File! :smile: :star_struck:
CSW_Success

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:
image

10

yes, we would use different columns.

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)

1 Like
11

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