Reading a CSV file as a Datatable

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

@rachelmcelhone

Can you share what’s the issue?

Thanks

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

@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

Have you change the delimiter ?
image

1 Like

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:

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

1 Like

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



@rachelmcelhone, you can test this method :

  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