Read only selected range column in csv

Help Activities
, ,
1

how to read Column “DD-1” To “DD-7” only read 7 column data

image
image1131×427 16.7 KB

3

Hi

Read csv file using read csv activity.

  1. Assign
    • To: filteredRows (IEnumerable)
    • Value:
      (From row In dataTable.AsEnumerable()
      Where row.Field(“DD”).StartsWith(“DD”)
      Select row).Skip(1).Take(7)

Thank you

4

No this is just example I have multiple column I cant use the count number

5

Hi @Garyy

1.Use ReadCSV activity
2.Use Filter Data Table and Add columns with your requirement as shown below.
3.Use Write csv activity.

image
image1416×744 50.3 KB

Hope it helps!!

6

Thank you but this solution is not what i’m looking

7

@Garyy

I have Updated the solution.Check, If not explain what you are looking for.

Hope it helps!!

8

in another scenario i have lots of column then its not working

9

@Garyy

We can able to read data only if we know number of columns to read or column range to read.

Regards,

1 Like