Reading a CSV file as a Datatable

Help
1

Hi

I am trying to read a CSV file into a datatable I have used the activity read CSV however it is not working, any advice? Please see screenshot of my work

image
image740×542 11.5 KB

2

@rachelmcelhone

Can you share what’s the issue?

Thanks

3

The issue is when i Output the table i cant see any information - as if the csv isnt pulling in the information

4

@rachelmcelhone

Can you share your CSV file screen and the Read CSV and Output Datatable properties screen?

If possible share your process with csv file which you are not able to get

Thanks

5

Have you change the delimiter ?
image

1 Like
6

Worked perfect. However my next issue is i then want to filter this datatable to get certain rows but the rpa is freezing when i do this:

image
image915×513 13 KB

7

If you need to filter a DataTable you can use the Filter Data Table activitie :
image

1 Like
8

I have tried this however it says the column is not set but i have declared it as a variable

image
image1014×604 17.5 KB

image
image1004×298 7.22 KB

image
image1205×193 15.8 KB

9

@rachelmcelhone, you can test this method :

image
image870×608 24.2 KB

  1. Create an Array of DataRow → DataRow
  2. Make your filter → MyDataTable.Select(‘Exampleheader1 = TEST’)
  3. You can pars the DataRow with a for each type argument system.Data.DataRow
    image