I have an array. Based on the array I am going to filter it.
I have tried following but was unsuccessful:
Generate Data Table Activity but it gives error(Can not generate data table because the input file is too big or contains too many rows ).
ODBC but it is changing number format.
Read text file the write CSV and then read CSV but it gives error due to rows more than 10.48 lakhs.
Filter the text file based in Array and keep the rows which contains the array value in first column.----but this also seems to be not possible.
ppr
(Peter Preuss)
July 3, 2024, 8:13am
2
when array ( we assume string array) is already loaded, so we can check if we will fiter directly e.g. LINQ Where:
This HowTo introduces how to use the Where operator.
Introduction
The Where operator is used for filtering. For the filtering, a condition is provided. All items matching this condition will pass the filter and will be part of the returned result.
The condition has mandatory to return a boolean outcome. In other words: The result of the condition has to be True or False.
Example
IPO
Samples
Comment
Values:
20,3,17,22,10,25,5
A collection of Numbers
Filter Condition:
x > 15
x is th…
Maybe you can share some samples
we would suggest to explore deeper the details. Also Segmenting the data and parsing it in chunks could be an option
could set the numbers to string, or any other preventive action can be checked
can use File.Read… or using a buffered stream reading for reading the file content
as mentioned a above LINQ Where can be checked
Array is set of account numbers which is also a variable. Cant use greater than or less than method. The data in text format and having 19 columns without header. The filter based on the array values is to be used to first column and all the values in the filtered rows for 20 columns should remain as it is like normal filter we use for excel or data table.
system
(system)
Closed
July 8, 2024, 5:30am
5
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.