Questions tagged [lookup]

Look up is related to indexes and hash tables. It is the action of accessing fastly to an item in a large collection thanks to a index (a so-called lookup table).

In computer science, a lookup table is an array that replaces runtime computation with a simpler array indexing operation. The savings in terms of processing time can be significant, since retrieving a value from memory is often faster than undergoing an 'expensive' computation or input/output operation.

The tables may be precalculated and stored in static program storage, calculated (or "pre-fetched") as part of a program's initialization phase (memoization), or even stored in hardware in application-specific platforms. Lookup tables are also used extensively to validate input values by matching against a list of valid (or invalid) items in an array and, in some programming languages, may include pointer functions (or offsets to labels) to process the matching input.

3604 questions
1
vote
2 answers

Newlookuprow not return 2 Informatica

I have a problem with the dynamic lookup of the Informatica. My new lookup row is only returning 0 (duplicate) and 1 (Insert) it never returns 2(update). When i added a new row with the same natural key and update a column in a row the lookup…
apoellitsi
  • 249
  • 6
  • 21
1
vote
2 answers

Talend Multiple Lookups

I'm starting to learn Talend and I'm facing this problem: I have several ID's as an input and I want to make a lookup for each of these ID's to output the obtain data in a Json output. Here's an image showing what I want to…
1
vote
1 answer

Get a Team from a Name column via lookup on multiple CSV files

Ok I have been coordinating the work of two ladies in order to get a complete csv I will want to import into our AD . Master spreadsheet $csvMasterData | Select-Object Name, Username, Mail, Business, Team, Role, Phone, Mobile Here my "Team"…
westerdaled
  • 231
  • 3
  • 15
1
vote
3 answers

Choosing and assigning a value based among the duplicate records in sql

My data looks as below: Student_ID State 1 WI 1 IL 1 IL 2 WI 3 IL 4 IL 4 MN I want my Output to be as follows: Ouput: If the same student is in both WI and any…
user3255656
  • 45
  • 1
  • 9
1
vote
1 answer

EJB lookup with InitialContext

I have a problem to look up a EJB hosted on a server. The server itself is an SAP environment, which is basicly a modified tomcat. I tried several lookupstrings starting with java:comp/env/ and ejb:/ but nothing works. This is what the server…
DI MI
  • 245
  • 2
  • 5
  • 16
1
vote
1 answer

Inverse lookup in pandas: get ordered lists of row- and column-names

Given lists of indices and columns, one can easily pull out the elements of a pandas DataFrame using the lookup() method. Is there a way to get the ordered lists of indices and columns from a given data frame (for example, after applying a boolean…
Noah
  • 21,451
  • 8
  • 63
  • 71
1
vote
1 answer

Refactor multiple intersections into groups of intersected unions

Given a set of rules which are a logical intersection of some known values (groups, types, properties) that combine to give some value as follows: group1 AND type1 AND property1 = value1 group1 AND type1 AND property2 = value2 group1 AND type1 AND…
Kyle
  • 1,366
  • 2
  • 16
  • 28
1
vote
1 answer

How to quickly populate a combobox with database data (VCL)

I have read all sorts of documents across the web about what should be a farly common and painless implementation. Since I have found no consistent and slick reply (even the Embarcadero website describes some properties wrong!) I am going to post a…
Dario Fumagalli
  • 1,064
  • 1
  • 16
  • 23
1
vote
1 answer

How to add data source to Lookup Edit at run time?

I have 2 Lookup edits in my winform. If I select 1st Lookup edit, need to add data source to 2nd Lookup edit based on what i selected in value in 1st Lookup edit. This all function can be done at run time. This code i use currently for 1st Lookup…
Srihari
  • 2,387
  • 9
  • 51
  • 82
1
vote
1 answer

Look Up Field in Access

I have two tables. One has information that is collected from an infopath form. The other has a list of names and employee ids. Is there a way to have a column in the first table that searches table 2 with an employee ID and looks up the name…
user2487016
  • 51
  • 1
  • 3
1
vote
0 answers

jboss-as-7.1.1.Final to jboss-5.1.0.GA ejb lookup

After seeing many variations of my question, I still have not found an answer yet so I would greatly appreciate it if someone gave me some insight. Can anyone tell me what is the best way to lookup ejb 3.1 on AS 5 (on a server) from AS 7…
Modumo
  • 23
  • 7
1
vote
1 answer

Fastest database engine to store huge string list

I have a huge unique string list (1.000.000.000+ lines). I need to know if a string does exist in this list or not. What is the fastest way to do it ? I guess I need a very simple database engine with a Btree index which lets me do fast lookup ...…
Antares
  • 177
  • 2
  • 12
1
vote
1 answer

Filter a lookup based on selection of the other in ms-access

I have two look up tables in an access database. I want the results of the Colleges Look-up to filer out the results of the Departments look-up. I have used [Forms]![Form]![College] to do this. It works the 1st time but when I choose a different…
Yousefrfk
  • 11
  • 1
1
vote
1 answer

Keeping code readable when using lookup tables - performance versus maintainability

Working on an audit system where possible event types are stored in a lookup table in the database, with GUID primary keys. For various reasons it's essential they're kept in the DB rather than stored in an Enum or something similar. Currently,…
Bob Tway
  • 9,301
  • 17
  • 80
  • 162
1
vote
2 answers

Excel extracting an exact string from cells with random structure

Ok so, In column A basically every cell has a different composition and doesn't have the same string Before And After the value we are looking to extract. For Example: ODODODODEFGH4OGOGOG LALALALALABCDE12-1ALALALALA IRIRIRIRIJKLMNOROROR And I…
1 2 3
99
100