Lookup a value in multiple columns of another project

[ThomasVee]

Hi,

 I realise one can lookup a column of values and add matching values from multiple columns in another project. But is there a way to lookup a column against multiple columns in another project and return, one or more values from another project.

My use case is this:

I have a column of placenames in project 1.

I have name, alternatename1, alternatename2...and so on to alternatename133, and latlong columns in project 2

I wish to lookup placenames in project 2, across the name and all alternatename columns and return the latlong value if a match is found in any of these columns.

Is that possible?

Thanks in advance,

Thomas

[Ettore Rizza]

Hi Thomas,

Sorry for that late reply, I thought someone had answered the question. 

The function cell.cross() (equivalent to VLOOKUP in Excel) does not allow a join based on multiple columns. In your particular case, I suggest you transform the alt_labels columns into rows using the "transpose cells across columns into rows" function, and then perform the join. 

Here is a screencast demo.

Hope this helps,

Ettore

[Thomas Vattakaven]

Thank you Ettore.

Thats fantastic. You guys do a stellar job answering every query here.

Thanks again.

Thomas

     The India Biodiversity Portal

Biodiversity Data Journal 4: e10279 (07 Nov 2016)

https://doi.org/10.3897/BDJ.4.e10279

--
You received this message because you are subscribed to a topic in the Google Groups "OpenRefine" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/openrefine/Twr8NwcOy3Q/unsubscribe.
To unsubscribe from this group and all its topics, send an email to openrefine+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.