HOW TO CHECK CSV HAVE VALUE OR NOT

Help Community
,
1

Hello guys, i have csv file in my project. I only want to process that data if the data having a value in that csv file, do u guys know how we do that in uipath using if condition

2

Hi @Kelvin1,

Check Datatable.Rows.Count() is equal to zero then the CSV has not any value.

3

Hi @Kelvin1

You can try like this

  • use read CSV activity and store in the datatable called DT
  • in if condition Dt.rows. Count >0

Regards
Sudharsan

4

Hi @sangeethaneelavannan1 and @Sudharsan_Ka thanks for the answer, gonna try it later.

6

@Sudharsan_Ka should i use the for each loop or just use if activity only after read the file?

7

@sangeethaneelavannan1 should i use the for each loop or just use if activity only after read the file

8

If activity should be fine

9

Just if @Kelvin1

10

Hi @Kelvin1

Readthe csv and store all data into DT.
Now DT.rows.count >0 it will gave you boolean results whether data is present or not.
in that way u can work.

11

HI @Kelvin1

Use If Activity DtRead.Rows.Count>0

Check out the image for better understanding

image

Regards
Gokul

12

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