Data filter not working
In Filter DataTable activity, you are checking for Etablissement is equal to 1/2/3/4/5/6 but your input Data doesn’t match with these values. That’s why you are getting empty DataTable as output.
And also I can see you used Excel Application Scope activity inside of another Excel Application Scope activity. I would suggest you to keep second Excel Application Scope activity after closing of first Excel Application Scope activity.
For your read range, did you click the box add header?
The filter contain more than 100 data value (1 to 200) its including “Etablissement” 114/91/220 and 38.
I tried to move the excel application after the first one but it doesn’t work
@raymondhui
Yes i checked add header
Before you do filtering, could you read the table and write it to see what does it read?
Besides, any space in the header? also is it string or int the value you choose?
Yes it read it , i use read and write the same sheet and it works
No space in the filter
String value (standard in excel)
After Filter DataTable activity, drag and drop one Message box activity and print the below expression and check it once.
TableHorsSiege.Rows.Count
Where TableHorsSiege is output of Filter DataTable activity and it is of type DataTable.
@lakshman
i have this :
That means Filter DataTable activity is giving empty rows. i.e. No rows are matching.
I have a row if its (vide) but if its a number i have nothing
I found the solution, i need to select preserve format in read range
@lakshman
its working but it takes too long time (hours)
I guess it’s due to PreserveFormat option you selected here.
And also May I know how many number of rows the input file has ?
You can try this expression
dt_New = dt_Original.AsEnumerable().Where(Function (row) etablissementNumbers.Contains(row("Etablissement").ToString)).CopyToDataTable()
Where etablissementNumbers is a list or array which contains all the Etablissement numbers that you want to keep.
This should work without PreserveFormat.
Best,
Charbel
@lakshman
200.000 rows
i need to put all my process in a for each row ?
This is a normal assign activity.
@Charbel1
yes but to select all my list on my excel file i need a for each row nn ?
ExcelBoucleEtable is my data table where there is my list
Which list are you referring to?
The Etablissement list?
yes etablissement list