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
1 answer

what would i need in order to build a price look up service or a price comparison service?

What id need it to do is login in to another websites account and look up prices for items as it applies to that user. this is because the users may have specific contract deals that gives them cheaper prices. id then need to show all of the results…
user3525985
  • 109
  • 7
1
vote
2 answers

Conditional join based on lookup

Apologies if a similar problem is posted earlier, I couldn't find the same. Problem: I need to join two tables based a conditional look up in the second table. Tables: Below are the two tables which have a subset of the total…
Vishal
  • 2,103
  • 2
  • 16
  • 18
1
vote
2 answers

Find nearest (lower) value from col B after matching col A

I have data as follows SHEET 1: A B K01 0.5 K01 0.8 K02 0.6 K03 0.6 .... I need to get the lowest nearest value from col B, where I supply col A and the nearest (higher) value to match from col B. For example: if the supplied…
TheRealPapa
  • 4,393
  • 8
  • 71
  • 155
1
vote
2 answers

Complex lookup in Excel

I have a worksheet which contains a list of parameters 'Parameters': A | B | C | D | E | Manufacturer | Item Type | Price From | Price To | Percentage | Apple | Mobile Phone | 0.00 |…
Richard Gale
  • 1,816
  • 5
  • 28
  • 45
1
vote
1 answer

Excel - How to see if a value starts with a value from a different column

I am trying to see if a value in one column starts with one of the values from another column. ie. col A col B col C Hel Good Bye YES Go Go Now YES By Stuff NO Something etc. …
DMCApps
  • 2,110
  • 4
  • 20
  • 36
1
vote
1 answer

lookup in excel 2007 over extended range

I have a spreadsheet with sorted information in the following form: name col1 col2 AAHEIM 1 2 AAHEIM 1 2 AAHEIM 9 3 AAHEIM 7 7 AAHEIM 7 6 AMSTERDAM 1 2 …
Gokotai
  • 153
  • 1
  • 2
  • 12
1
vote
3 answers

Fast lookup in a multidimensional System.Collection.IList

I need your advice on the following. I have a multi-dimensional IList containing items which have an index, Id and Text. Normally I know the value of Id and based on that I need to get the Text. Both Id and Text values are read from a database. What…
All Blond
  • 802
  • 1
  • 8
  • 16
1
vote
2 answers

Why does having an index actually speed up look-up time?

I've always wondered about why this is the case. For instance, say I want to find the number 5 located in an array of numbers. I have to compare my desired number against every other single value, to find what I'm looking for. This is clearly…
Adam Bronfin
  • 1,209
  • 3
  • 27
  • 43
1
vote
2 answers

Modelling Lookup Values in Domain

In domain driven design, I have the following situation. I have a Vehicle model. The vehicle can be of type HatchbackCar, SedanCar, Truck etc. The VehicleType is stored in a database lookup table. Question is: How do I model the Domain? Do I Model…
1
vote
1 answer

Vectorization of min distance in kernel

I have an Nx2 array K1 with the location of N keypoints and a 3 dimensional WxHx3 array Kart1(width,height,coordinates) that maps coordinates to every pixel of an image. For every keypoint in K1 I want to read the location of the pixel in Kart1 and…
McMa
  • 1,568
  • 7
  • 22
1
vote
2 answers

Custom lookup select issue

The idea is to contruct a lookup with unique Employer name. The lookup works fine but when I select a value and then select the lookup button again and click on the place marked in RED, there are duplicate values, which is wrong. Kindly refer the…
piku
  • 471
  • 4
  • 12
  • 44
1
vote
0 answers

Sharepoint - Update Values in a multi-value Lookup from a workflow attached to another list

I have three lists: Languages, Files, Components. Components has a Multi-Value Lookup column to Languages. Files contains translation files associated with components in the Components list. When a new translation file is received via email, a…
Mars7272
  • 51
  • 4
1
vote
5 answers

lookup Data in Excel

I have a 2 variable 100x100 data table in excel. I need to have a function that returns all the possible sets of variables that yield a given target value. What I am looking at is some kind of a reursive 2 dimensional lookup function. Can someone…
Vaibhav Garg
  • 717
  • 5
  • 15
  • 31
1
vote
1 answer

SSRS nested iif expression in lookup

I'm brand new to SSRS and could use some help: is it possible to nest a lookup expression inside an iif statement? I have a web form with checkboxes and would like to change the answer text from "True" and "False" to "Agree" and "Disagree", but…
GoldAnchor
  • 129
  • 4
  • 13
1
vote
1 answer

SQL Server diagram filters look up tables

When I am adding tables to Database Diagram in SQL Server 2012 it doesn't let me to add look up tables. It just filters them out from the tables list. Is that standard behavior?
Vlad K
  • 113
  • 1
  • 8