Filter datatable not found value?

Help Activities
, ,
1

I use activity filter DataTable as below.

image
image806×573 14 KB

But after filter output not found that match with condition.

But If I use write range first —> read range —> filter activity have found condition.

Please guide me about it.

2

@fairymemay

Can you please print the DataTable row count below Filter DataTable activity and check whether it holds any data or not.

       DT_Detail.Rows.Count
3

@fairymemay

If it doesn’t give any output then we have two possibilities.

  1. DT_Input variable doesn’t hold any data or
  2. There are no rows matched with the specified condition in the given data.
4

@lakshman Now I use flow as below.

image

5

@lakshman My textfile as attched.
text.txt (855 Bytes)

6

@fairymemay

Is Generate DataTable activity generating DataTable properly ?

7

@lakshman

My flow as attached.
Main.xaml (8.4 KB)

image
image1664×699 47.2 KB

From condition filter → output should 2 rows.
image

8

@lakshman Any idea for solve it ?

9

@fairymemay

Specify New Line separator as newline here. Did you enter any input data to see the preview ?

10

@lakshman Preview data as below.

image
image1342×739 53.6 KB

11

@fairymemay

It looks good to me. Can you pass column index instead of Column Name into the Filter DataTable activity and check once.

Column Index will start from 0 onwards.

12

@lakshman How to pass column index?

13

@fairymemay

If you are filtering based on first column then pass 0 without double quotes.

14

@lakshman Output as same.

No data after filter.

15

@fairymemay

Please find the attached workfow for your reference.

Fairy_DataTableTask.zip (56.5 KB)

1 Like
16

@lakshman If I have file config for keep date for filter as below.

image
image890×153 4.58 KB

If filter column APADT (for filter from column Start_APAPDT and End_APAPDT) and filter APDODT (for filter Start_APDODT and End_APDODT)

  • Sometime file config have 1 row or more than 1 rows.
    config2.xlsx (8.9 KB)

Please guide me about it.

17

@lakshman Can you guide me more about it?

From your code

dtOutput = dtInput.AsEnumerable.Where(Function(row) Cint(row("APAPDT").ToString) > 25650101).CopyToDataTable
18

@fairymemay

The above expression is called Linq query.

Here, we are reading all rows from DataTable and and then converting APAPDT column value into String and checking whether its value is greater than 25650101. If rows found with matching criteria then it will assign all rows into dtOutput variable and it’s of type DataTable.

19

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