Questions tagged [filter]
A program or routine that rejects or accepts data that meets a given criterion. An example would be a filter that removed entries less than a given limit from a set of values. Do NOT use this tag for: Signal or image processing, use [filtering]. Java servlet filters. Use [servlet-filters]. For Bloom filters, use [bloom-filter]. For CSS filters use [css-filters].
filter
32,398
questions
-1
votes
1
answer
46
views
How to merge two array using .map and .find by avoiding iterating twice
I have two arrays below. I am trying to merge conditions array based on customerLOB.code match. The problem is, I am getting the results added twice because the loop gets iterated twice. How can I ...
- 989
-4
votes
1
answer
33
views
how to extract files from a list using substring filter [duplicate]
I have a list of files from os.listdir like:
TXSHP_20240712052921.csv
TXSHP_20240715045301.csv
TXSHP_FC_20210323084010.csv
TXSHP_FC_20231116060918.csv
how do I extract only the ones where 'FC' is ...
- 362
0
votes
0
answers
28
views
Cannot use IN function for Partition Filter of a View Table in BigQuery
so I have a view table named table_1 and it has a partition field called business_date. Thie table_1 is constructed by using a raw table named data_mart.customer_raw.
There are a lot business needs ...
- 319
0
votes
0
answers
39
views
Dependent Pivot Drop Downs
I am hoping someone can help. My search thus far has yielded no results, and I refuse to think this hasn't been released yet.
I have a Pivot of an extremely large set of data. In the filters is a ...
- 223
1
vote
2
answers
78
views
Filtering specific sequences in R
I am trying to filter a dataset I have obtained after RNASeq Analysis. I have "Sequence Name" assigned to "topological domain" and "transmembrane region". I would like to ...
- 11
1
vote
1
answer
22
views
SQL Group By Then Filter [duplicate]
I have two tables as follows:
Table A : contacts
Contact_Primary_Num
Displayed_Name
1
Smith, Joe
2
Doe, Donna
3
Jerry, Tom
4
Crocker, Betty
Table B : contact_notes
Contact_Note_Primary_Num
...
- 29
0
votes
0
answers
40
views
How to delete duplicates in a table?
I have written a software that every second copies the contents of a JSON file from a server into a variable (serverData). Using the json-path library I extract some information from the serverData ...
- 1
0
votes
1
answer
57
views
xml.etree.ElementTree. Element object has no attribute 'nsmap'
I try to process xml data from the website https://www.marktstammdatenregister.de/MaStR/Datendownload
I downloaded some datasets for a certain technology for example Netzanschlusspunkte. First step ...
- 349
-2
votes
0
answers
30
views
How to changing checkbox in table only for filtered position Access [closed]
I have an Access database where I have a lot of checkboxes in Table, I need to change the data to yes/no only for filtered items
what better way to do it? via VBA or Query
I made a query but it ...
-1
votes
0
answers
8
views
Why "info@" filter does not work in Gmail?
I have a list that filters out junk and automated emails. However, no matter how I try, if I put any form of "info@" into the list, the entire list becomes unusable and when editing, it no ...
- 33
0
votes
1
answer
15
views
Vlookup + Filter + Sort + Arrayformula workaround in google sheets
I have two tables, RECORDS and TYPES.
Link to a similar spreadsheet
RECORDS has 3 columns, "Type" in column A, "Entry Date" in column B, and "Status on Entry Date" in ...
- 19
0
votes
1
answer
29
views
Add a value to filter result in Google Sheets
I have the following formula that works in Google Sheets
=Sort({IFERROR((FILTER({'My Log'!B13:B, 'My Log'!F13:F, 'My Log'!E13:E, 'My Log'!H13:H, 'My Log'!I13:I,'My Log'!J13:J, 'My Log'!K13:K,'My ...
- 1,141
0
votes
0
answers
23
views
How to keep ag grid filter after selecting all filtered?
I have an ag grid table that I am filtering, and upon a button click it is set to select all the rows that are currently filtered using selectAllFiltered(), and after clicking the button the filtered ...
0
votes
1
answer
27
views
How to construct a Map with conditional items with typescript
I want to add an item to a Map conditionally, and adding .filter but I'm getting Type 'null' is not assignable to type 'readonly [string, Book]'.(2769). This is only issue when adding item ...
- 9,240
3
votes
1
answer
125
views
Primes using setjmp
I wrote a simple Haskell function, that gives a list of primes.
primes' :: [Int] -> [Int]
primes' (p : xs) = p : primes' (filter (\x -> x `rem` p /= 0) xs)
primes :: [Int]
primes = primes' [2 .....
- 71