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
3 answers

Reverse lookup for Java Enums with more than one value per key/constant?

With an enum like this one where each key has several values ABBR1("long text 1", "another description 1", "yet another one 1"), ABBR2("long text 2", "another description 2", "yet another one 2"), //and so on... how can I reverse lookup an…
Christian
  • 6,070
  • 11
  • 53
  • 103
1
vote
1 answer

Excel Pivot Table - How to retrieve value of cell in Rows section

I have some raw data as shown below. I created a Pivot Table for it, mainly just for formatting purposes (the ability to nicely group and expand the sub-items). The Pivot Table is shown below. I need to display the LastUsageTime for each of the…
AngieM
  • 735
  • 6
  • 27
1
vote
2 answers

.NET values lookup

I have a feeling of missing something obvious. UDP receiver application. It holds a collection of valid UDP sender IPs - only guys with IP on that list will be considered. Since that list must be looked at on every packet and UDPs are so volatile,…
Maciej
  • 7,871
  • 1
  • 31
  • 36
1
vote
1 answer

MYSQL - Getting the value from a field in a lookup table and main table in the same query

I have 2 table which I will describe below: 1) The main table which has an auto increment by U_ID and has a column named RU_ID which refers to the ID of a lookup table. 2) The Lookup table is auto incremented by RU_ID and has a column named ROLE…
jwknz
  • 6,598
  • 16
  • 72
  • 115
1
vote
3 answers

Why doesn't LOOKUP match the first element in an array?

Here is the screenshot of my excel workbook I do not understand why the value in cell j7 is 44 ? j7 formula is =LOOKUP(1,(TRIM($D$2:$D$9)=TRIM(H7))/(TRIM($E$2:$E$9)=TRIM(I7)),$F$2:$F$9) The result of the two arrays division is the following…
Buras
  • 3,069
  • 28
  • 79
  • 126
1
vote
1 answer

Why does SSIS lookup return null value?

I'm having an issue with a SSIS Lookup component. My source table has a string value (XXX), and I need to know if it exists on another table. If I make a query like select AAA from dest_table where AAA = XXX I DO get a matching result. This value…
Neko069
  • 49
  • 1
  • 9
1
vote
0 answers

Bulbflow Neo4j Index Lookup Error - Multiple results on lookup with unique key

A node with record class is stored with a unique record_id. The class definition for a record is this: class BaseRecord(Node): element_type = "baserecord" rec_id = Integer(nullable=False,unique=True) name =…
Denny_Crane
  • 106
  • 5
1
vote
1 answer

SSRS 2012 Lookup Function Returns No Data

I have an SSRS 2012 Report that is based on a MetricsData dataset that contains the field "REPOSITORY". The report also has a second dataset, PlanITData, containing the fields: RepositoryName AppName AppOwnerName I put an expression into one of the…
Richard Schaefer
  • 525
  • 3
  • 13
  • 45
1
vote
1 answer

Do nothing with (no) match output in the lookup transformation (SSIS)

I'm new to SSIS as well as Stackoverflow. Here's my situation. I'm building a database and an archive database which need to be synced daily. The records in the database need to be copied to the archieve. I use SSIS and daily jobs to do this.…
Kim
  • 393
  • 2
  • 8
  • 18
1
vote
1 answer

SSRS 2008 Need to lookup customer name with largest order

I'm creating an SSRS report which contains a table of orders, grouped by day. Now I can easily get the max order value for the day and put it in the group header by using the SSRS MAX() function. However, I also want to get the corresponding…
Chris
  • 183
  • 1
  • 10
1
vote
1 answer

Rails: Shorthand for making a lookup hash?

I'm making a lookup hash on a Model from a unique name to a unique ID lookup_hash = Hash[*Country.pluck(:name, :id).flatten] => lookup_hash = {"America" => 12, "Brazil" => 2, "China" => 51...} That way I have an object that requires a single SQL…
Nelson C.
  • 11
  • 1
1
vote
1 answer

Dynamics AX 2012 - Custom Lookup in a dialog

So, I am working on a class called DMFWriteExportData and trying to get it run in Batch. I am at a point where I need to figure out a way to get rid of fieldControl and the reason being it does not let me Run the class on the server and throws an…
khosla
  • 29
  • 1
  • 6
1
vote
1 answer

Sum From Lookup SSRS Reporting services

If i take a 4 day period it only shows capacity from the latest day, but I need to show the total capacity over 4 days. I try to sum the capacity wich is a lookup that looks like this: =Lookup(Fields!ID.Value,Fields!Name.Value,Fields!capacity.Value,…
Edvard Åkerberg
  • 2,181
  • 1
  • 26
  • 47
1
vote
0 answers

JNDI lookup failed from different VM

When doing a lookup on a JNDI server from within the same vm that started the server (being part of a spring web app), resources that are bound to JNDI (in this case JMS queue and connection factory) are returned as expected. When connecting to the…
Florian
  • 1,142
  • 1
  • 9
  • 21
1
vote
0 answers

Lookup ff vectors using ffvecapply

I am trying to substitute values of an ff vector using two other vectors. With RAM objects it is straightforward: w <- 3:6; w1 = 1:10; w2 = letters[1:10] # a way to do it: sapply(w, FUN=function(x){ w2[which(w1 == x)] } ) [1] "c" "d" "e" "f" ff…
Audrey
  • 212
  • 4
  • 15