FAQ Database Discussion Community


Open VF page when clicked on lookup icon with conditional records

set,salesforce,lookup,apex
i am trying to get this running with some modifications. http://blog.jeffdouglas.com/2011/08/12/roll-your-own-salesforce-lookup-popup-window/ I have to get those accounts of which my contact is having contact role and account which it belongs to. I have written soql query and having different accounts from two ojbects. I saved the list as set to...

Sum fields in a column if there is an entry in a corresponding row in another column

excel,sum,excel-formula,lookup
Assume the following data: | A B C --+------------------------ 1 | 2 3 5 2 | 2 3 3 | 4 4 4 | 2 3 5 | 5 6 In cell A6, I want Excel to add cells C1, C2, C3 on the basis that A1, A2 and A3...

Horizontal Leader Board based on organisation

excel-formula,lookup,ranking
I am trying to work out the ranking of top 3 users at different organisations and have the data presented horizontally for each user so it can be inputted into our email system to personalise emails. I am able to create a ranking vertically but I am not sure how...

SSIS Compare tables content and update another

sql-server,ssis,lookup
I would like to compare two tables, one from Access Mdb & one SQL server table is SSIS. The goal is to truncate the table if there is differences and fill it with MDB source and Update the version in another table. I am trying to do it through a...

Are there CSV files or lookup table to correct for real north now and in the future?

csv,gps,embedded,lookup,compass
I am currently working on placing a compass on an embedded microchip PIC32 family device I am working on. The compass is made in another part of the world and once assembled I want to be able to use it in other parts of the world without having to re-calibrate...

Map Lookup Efficiency of TestForNull

java,performance,dictionary,lookup
Referencing a previous answer to a question on SO, there is a method used called TestForNull. This was my original code before I was told I could make it more efficient: My original code: for (int i = 0; i < temp.length; i++) { if (map.containsKey(temp[i])) map.put(temp[i], map.get(temp[i]) + 1);...

In XSLT 1.0 how to create a lookup function on XML data embedded in the XSLT using key and document('')?

xslt,key,document,lookup,xpath-1.0
My specific need is to lookup line-heights given a particular font-size, but I am seeking to learn a general technique of creating lookups/a specific mapping. I think it is possible to embed XML in the XSLT document itself (so it can work standalone) and build a key on it using...

Mapping Appointment Entity for Data Migration in Microsoft Dynamics CRM 2015

dynamics-crm-2011,lookup,dynamics-crm-2015
I need to migrate data from CRM 2011 to CRM 2015 for different entities. I am using scribe insight for this purpose. I am stuck with the the migration of different entities belonging to Activities like Appointment, Letter, Fax, etc. If its a normal lookup field i would have used...

Finding ID based on first and last name

excel-vba,lookup,excel-2013
I have a list that contains Employee ID in Col A, First Name in Col B, Last Name in Col C. I am needing to write a macro that gives a userform to input First and Last Name and from there it will put the proper Employee ID into the...

Perl substitution - lookup table issue

regex,perl,hashtable,lookup,substitution
I have a ~35MB KML file where all the placemarks are named "kml1234" and the like. I want to replace the name with a readable string like "Area 9987" and I have the lookup table. I found a snippet of perl here (http://stackoverflow.com/a/6435950) and it worked for the majority of...

Lookup a Value and Display Column Header

excel,if-statement,excel-formula,lookup,worksheet-function
aaa bbb ccc D 1 5 9 # (aaa, bbb or ccc) 2 6 10 3 7 11 4 8 12 I am trying to find a formula (to go in D2) so that the number matches its column header (aaa, bbb or ccc). For example if I put 5...

How to return no matched row in Pentaho Data Inegration (Kettle)?

java,pentaho,lookup,etl,kettle
I look for a solution to perform SSIS lookup in Pentaho Data Integration. I'll try to explain with an exemple : I have two tables A and B. Here , data in table A : 1 2 3 4 5 Here , data in table B: 3 4 5 6...

R Creating a Character Column from a Numeric Column w/o using For Loop

r,for-loop,mapping,character,lookup
I am trying to create a column of characters based on an existing column of numbers, preferably without using a for loop. I have come up with a variety of ways to do this, but I keep feeling like I'm making this far more complicated than it needs to be....

simple lookup in R by ID and Time

r,data.table,lookup
I have a dataset that looks like this: set.seed(1234) DT<-data.table(id=c(rep(c("a","b","c","d"),5)), year=rep(seq(from = 2010.5,to=2012.5,by = .5),each=4), value=rnorm(20,10,1)) DT id year value 1: a 2010.5 8.792934 2: b 2010.5 10.277429 3: c 2010.5 11.084441 4: d 2010.5 7.654302 5: a 2011.0 10.429125 6: b 2011.0 10.506056 7: c 2011.0 9.425260 8: d...

SSIS Lookup multiple identical databases

ssis,components,integration,lookup,multiple-databases
I'm working on a project where i need to do lookups on a data warehouse server in Integration Services. My problem is that I need to be able to change what database it i performs the lookup to. The databases are design wise identical. I have solved this problem with...

Return the smallest value from a list, in which only certain values are eligeble - excel

arrays,excel,list,indexing,lookup
I am having some troubles formulating my problem but I hope you understand! I have a table of firms building production plants in foreign countries in certain years. (Columns A to C). In a seperate table i have so-called cross-national distance measures (based on the difference in gdp of the...

How to hard-code legal moves for fast lookup?

java,arrays,lookup
I have created a gameboard (5x5) and I now want to decide when a move is legal as fast as possible. For example a piece at (0,0) wants to go to (1,1), is that legal? First I tried to find this out with computations but that seemed bothersome. I would...

Python : The most efficient way to join two very big (20+ GB) datasets?

python,join,dictionary,lookup
I have a 21 GB dataset df_ns: domain|ns 123.com|ns1.domanihost.com hymi.net|ns2.hostinger.com and another 12 GB dataset df_ip: ip|domain 28.76.2.2|myname.com 86.90.234.5| 123.com and I would like to join them on domain name and for the domains that are in both files extract ip and ns. The way I thought of using it...

INDEX MATCH VBA (return a value based on two criteria)

excel,vba,excel-vba,lookup,formulas
I'm doing some work for a client where they receive a weekly report of customers and regions (two columns, A for Customer & B for Region, in a worksheet). * I've omitted the other columns in this spreadsheet for the sake of clarity They need to match the price on...

Dictionary Value lookup performance

c#,performance,dictionary,lookup,pseudocode
I am working on a small project but have run into a performance roadblock. I have a Dictionary<string, string>() I have a string[]. Lets say my Dictionary has 50,000 entries, and my string[] has 30,000 entries. I want to collect the Keys from my Dictionary where the value.ToCharArray().OrderBy(x => x)...

Python do a lookup between 2 dictionaries

python-2.7,dictionary,lookup
I am trying to summarise two dictionaries as follows: mydict = {41100: 'Health Grant', 50050: 'Salaries', 50150: 'Salaries', 50300: 'Salaries'}; mytb = {'': '', 41100: -3,450,200.40, 50050: 1,918,593.96, 50150: 97.50, 50300: 8,570.80} My output should be: { 'Health Grant': -3450200.40, 'Salaries': 1927262.26 } Can you help with coding the for...

Google Sheets - Array Formula, match, lookup

indexing,google-spreadsheet,match,lookup,array-formulas
I Just cant mange this - Help Im trying to do something but just cant manage it. If you look at the image below you will see Username, Sponsor, Referral 1, Referral 2. IMAGE of spreadsheet - http://imgur.com/60Omdp7 Now what i want to do with a formula is E&F or...

interpolation/lookup in R

r,gps,interpolation,lookup
I'm switching to R from excel and was wondering how to do this in R. I have a dataset that looks something like this: df1<-data.frame(Zipcode=c("7941AH","7941AG","7941AH","7941AZ"), From=c(2,30,45,1), To=c(20,38,57,8), Type=c("even","mixed","odd","mixed"), GPS=c(12345,54321,11221,22331)) df2<-data.frame(zipcode=c("7914AH", "7914AH", "7914AH", "7914AG","7914AG","7914AZ"), housenum=c(18, 19, 50, 32, 104,11)) First dataset contains zipcode, house number range (from and to), type meaning...

Perl outputs too many columns

perl,match,lookup
I have one table of associated marker results and one table of disease markers. Both files have headers. This is what the associated marker table looks like: snps_BCG24 gene_BCG24 statistic_BCG24 pvalue_BCG24 FDR_BCG24 beta_BCG24 pair SharedOrUnique_BCG24 PercentileRank_BCG24 chr cM hg19pos Diseasegene rs11203184 C21orf128 -9.425704 4.008530e-12 2.501741e-05 -0.9199033 rs11203184_C21orf128 SharedSignalMO7 1.484874e-06 21...

SQL Select Text for multiple foreign keys to lookup table in same row

sql,table,join,foreign-keys,lookup
I have a table similar to the following that has a history of changes to an item and holds the old and new value for a status. The status number is a foreign key to a lookup table that holds the text. I.e. 1 = 'In Inventory', 2= 'Destroyed' etc.....

Excel - See if cells in one column contain text from another

excel,search,contains,lookup
Currently I am using the below to see if cells in column B exist in Column A... =IF(ISERROR(MATCH(B1,A:A,0)),"False","True") ... However I've just realised the need to not check for an exact match, but rather if the cells in column B contain text that appear in any of the cells in...

How to look up (or match) two criteria and then average any value that matches those two criteria

google-spreadsheet,average,lookup,gs-vlookup
I have two sheets. On sheet #1, column A is made up of publishers (publisher 1, publisher 2, publisher 3, etc.), and row 1 is made up of topics (topic 1, topic 2, topic 3, etc.). On sheet #2, column D lists the publishers, and column F lists the topics...

Combining lookup and offset

excel,offset,lookup
I would like to offset the last entry in my data by one week. For example, I just created this example data: day value 1 4 2 3 3 5 4 6 5 1 6 3 7 9 8 5 To find the last entry in the dataset, I use...

ssis swap some values in a data flow if they match a lookup table

ssis,sql-server-2008-r2,transform,lookup
Here's my problem - Midstream in my data flow, we have some values in one column that we want to swap for other values based on a lookup table. For example, if I had a rowset like this: Key Value 1 A 2 B 3 A 4 C 5 D...

To look an EJB , i have to deploy the implementations .jar or interfaces .jar?

java,jboss,ejb,jndi,lookup
I try to look up and EJB under jboss EAP6. I have 2 mavenized projects : Interfaces where I have justeinterfaces. Implementations where I have only the implementations of interfaces and my tests classes (I use testNG) My question is: Do I have to deploy on the server the interfaces...

INDEX MATCH multiple criteria not working (#N/A)

excel,indexing,match,lookup
I am attempting to match 2 criteria (drug generic and drug pack size) in an INDEX MATCH formula to cross-reference 2 databases I have. Despite reading several posts on this and other sites I just cannot get these to work. Working in Office 2010. Formula 1 attempt (referencing 3rd column...

How can I match or lookup a value on Excel?

excel,match,lookup
I got these 2 questions in an exam, and as easy as they sound, I couldn't get them right. So I have this table. And the questions are: 1- Using a function, What is the price of the first Diesel car that appears on the list? 2- Using a function,...

Lookup Multiple Items

excel,excel-formula,lookup
I have a list of names and numbers NAME | Number Joe | 1 Jane | 0 Jack | 1 Jill | 0 John | 1 I'm trying to look up the numbers and find out the corresponding name The formula I have is {=index($A$2:$B$6, SMALL(IF($B$2:$B$6 = 1, ROW ($B$2:$B$6)),...

Using Lookup or Index - If a certain placing, then place the name

if-statement,indexing,excel-formula,match,lookup
I would like to provide the name of the competitor if they placed first. In different cells, I will like the same for second place to fifth place. My purpose is because there are many divisions, 27, and each are on different worksheets. It would make it easier to have...

Regarding subdomain without parent domain [closed]

dns,lookup
I received an email from mails.sukshmailers.com but if try to lookup (find ip address)sushmailers.com it shows no record exists but if try lookup for mails.sukshmailers.com record exists My question is can domain name contain (.) dot symbol like mails.sukshmailers if mails.sukshmailers.com is subdomain of sukshmailers.com why can't i find ip...

Equalivalent of SAS format (in R)

r,table,merge,lookup
Suppose I have a dataframe: sick <- c("daa12", "daa13", "daa14", "daa15", "daa16", "daa17") code <- c("heart", "heart", "lung", "lung", "cancer", "cancer") sick_code <- data.frame(sick, code) And another: pid <- abs(round(rnorm(6)*1000,0)) sick <- c("-" , "-", "-", "-", "daa16", "SO") p_sick <- data.frame(pid, sick) Now i would like to add a...