Lookup table ? Something like Excel's vlookup?

Follow

AP

• April 10, 2017 09:17

Hi There, 

  I am looking for functionality that allows me to create a column in a sheet by lookingup values from another sheet? As explained in the screenshot:


This operation is similar to the vlookup operation in MS Excel. Is there a easy way to achieve this in Datameer?

 

0

• 

  Konsta Danyliuk

  • April 10, 2017 09:38

  Hello.
  
  We don't have Excel vlookup analog in Datameer. But, seems, you could achieve mentioned goal by joining UserSheet and ProductLookup sheets by ProductGroup and then apply Group function (if required) to transform the data further.

  Does this make sense?

  1

  Comment actions Permalink
• 

  AP

  • April 10, 2017 11:04

  Thanks, I tried Outer Left Join which gives same result.

  

  0

  Comment actions Permalink

Please sign in to leave a comment.